On Wed, 27 Aug 2008, Jerry Champlin wrote:
> After it's a day old, there are no longer any updates or inserts and we
> can vacuum it at that point.
A pattern that has worked very well for other people is to have two
separate tables (or partitions). One contains today's data, and the other
contains historic data that is no longer updated. Once a day, transfer the
data between the partitions, and the historic data partition will not need
Some changes to your code will be needed however.
Vacuums are nothings. We only mention them to let them know we know
In response to
pgsql-performance by date
|Next:||From: Shane Ambler||Date: 2008-08-27 16:45:52|
|Subject: Re: select on 22 GB table causes "An I/O error occured
while sending to the backend." exception|
|Previous:||From: Tom Lane||Date: 2008-08-27 14:01:50|
|Subject: Re: Is there a way to SubPartition? |