The recommended partitioning guideline is if your table exceeds 2G
Partitioning benefits:
1. Purging old data very quickly (this is one of the biggest
benefits...especially if you have to purge very often...dont even
think of using DELETE)
2. Performance for certain types of queries where full
Hi,
We currently have a large table (9 million rows) of which only the last
couple of days worth of data is queried on a regular basis.
To improve performance we are thinking of partitioning the table.
One idea is:
Current_data = last days worth
archive_data today (goes back to 2005)
The idea
--
From: pgsql-performance-ow...@postgresql.org
[mailto:pgsql-performance-ow...@postgresql.org] On Behalf Of Radhika S
Sent: Thursday, December 24, 2009 8:12 PM
To: pgsql-performance@postgresql.org
Subject: [PERFORM] Performance with partitions/inheritance and multiple tables
Hi