Re: [PERFORM] un-'vacuum analyse'

2006-03-31 Thread Tom Lane
Frederic Back <[EMAIL PROTECTED]> writes: > Is there a way to de-'vacuum analyse' a database for > testing purposes? "DELETE FROM pg_statistic" will get you most of the way there. It doesn't get rid of the accurate relpages/reltuples entries in pg_class, but since CREATE INDEX also updates those c

[PERFORM] un-'vacuum analyse'

2006-03-31 Thread Frederic Back
Hello, I would like to know how my application works before and after data from VACUUM ANALYSE is available. Is there a way to de-'vacuum analyse' a database for testing purposes? Thank you, Fred ---(end of broadcast)--- TIP 1: if posting/reading