Re: VACUUM and ANALYZE Follow-Up - Mailing list pgsql-general

From Tom Lane
Subject Re: VACUUM and ANALYZE Follow-Up
Date
Msg-id 22133.1101759969@sss.pgh.pa.us
Whole thread Raw
In response to VACUUM and ANALYZE Follow-Up  ("Mark Dexter" <MDEXTER@dexterchaney.com>)
List pgsql-general
"Mark Dexter" <MDEXTER@dexterchaney.com> writes:
> Several recent postings appear to confirm that there is an issue with
> the use of VACUUM or ANALYZE on empty tables.  Specifically, if you
> VACUUM or ANALYZE a table that is empty and then insert a large number
> of rows into this table, you will experience very poor performance.

Well-known issue.  See this thread for the latest discussion:
http://archives.postgresql.org/pgsql-hackers/2004-11/msg00985.php

            regards, tom lane

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: VACUUM and ANALYZE Follow-Up
Next
From: Martijn van Oosterhout
Date:
Subject: Re: VACUUM and ANALYZE Follow-Up