Re: VACUUM and ANALYZE Follow-Up

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mark Dexter" <MDEXTER(at)dexterchaney(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: VACUUM and ANALYZE Follow-Up
Date: 2004-11-29 20:26:09
Message-ID: 22133.1101759969@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Mark Dexter" <MDEXTER(at)dexterchaney(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2004-11-29 20:47:51 Re: VACUUM and ANALYZE Follow-Up
Previous Message Joshua D. Drake 2004-11-29 20:08:28 Re: VACUUM and ANALYZE Follow-Up