On Wed, 2020-12-16 at 14:44 -0500, Jack Orenstein wrote:
> What are the pros and cons of partitioning the table?
Pro:
- it bebomes easier to get rid of old data
- autovacuum is more fun with several smaller tables
- a few select queries might become faster
Con:
- administrative overhead (creating and dropping partitions)
- most queries become slightly slower
> Without partitioning, are we liable to run into trouble as this table keeps growing?
That is hard to answer. If it works fine with 5*10^9 rows, it might also
work fine with more data.
The deciding factor might be getting rid of old data. That can be quite
painful with a single large table, but it might be trivial with partitioning.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com