Re: Size for vacuum_mem

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.