0

Postgres has a limit of 32T in a single table, but what if the table is partitioned - is that 32T per partition now?

  • 2
    Yes, a partition counts as (and is) a single table – a_horse_with_no_name Jun 18 '16 at 15:00
  • 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
0

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.

  • 1
    Well, I work with Pb of data, so yeah, pretty funky ;-) – Gaius Sep 8 '17 at 17:51
  • Fair enough. That's a lot of data. – Evan Carroll Sep 8 '17 at 17:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.