> -----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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
