On 4 Dec 2002, Neil Conway wrote:
> > Currently a vacuum full takes 3+ hours and very soon the amount of data
> > will increase.
>
> Do you need to use VACUUM FULL?
I have a very large turnover ratio.
For some tables I delete/reload the whole table daily (tables in the 500K
to 1.5 Million records), while other tables I delete/reload about 1/3 (ie
7 Million records table I delete/copy 1.5 Million records).
The reason for the delete/copy is that the data is coming from a system
where there is now way to tell what was added, changed since the last
update. So I use date ranges for some tables and do entire tables for
others.