Re: Size for vacuum_mem

"Francisco Reyes" <lists@natserv.com> writes:
> On 4 Dec 2002, Neil Conway wrote:
>> 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).

For the delete/copy scenario, you could avoid the need for VACUUM by
using TRUNCATE, if you don't mind the fact that TRUNCATE isn't
rollbackable (yet).

            regards, tom lane