> -----Original Message-----
> From: Denis BUCHER
>
> And each morning huge tables are DELETED and all data is
> INSERTed new from a script. (Well, "huge" is very relative,
> it's only 400'000 records)
If you are deleting ALL rows in the tables, then I would suggest using
TRUNCATE instead of DELETE. Truncate will be faster deleting and it will
not accumulate dead tuples.
Also if you switch to truncate then you should ANALYSE the tables after you
finish inserting. Note that VACUUM ANALYSE is not necessary after a
truncate/insert because there should be no dead tuples to vacuum.
Dave
