How are Postgres partitions counted for the table size limit? Postgres has a limit of 32T in a single table, but what if the table is partitioned - is that 32T per partition now?
So just to be clear, a table with two partitions would effectively be a maximum 64T table? This aligns with my understanding of the underlying mechanism (same as Oracle's) but I wondered if there was something I missed. – Gaius Jun 18 '16 at 17:08


Yes, that's true. Just to be clear. As @a_horse_with_no_name said partitions are implemented as different tables.

Though if you have more than 32T in a single table, even if partitioned, I would think something is funky.