Home > mailing lists

VACUUM Performance - Mailing list pgsql-performance

From	Steve Oualline
Subject	VACUUM Performance
Date	October 20, 2006 22:14:55
Msg-id	00C5463E8A5F7C41A8396D701A6734B1527A62@mail01.stbernard.com Whole thread Raw
Responses	Re: VACUUM Performance (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-performance

Question: I have a big table with 120,000,000 records.

Let's assume that I DELETE 4,000,000 records, VACUUM FULL, and REINDEX.

Now I have the same table, but with 240,000,000 records.

I DELETE 8,000,000 records, VACUUM FULL, and REINDEX.

Should the second operation with twice the data take twice the time as the first?

From: alvis
Date: 20 October 2006, 20:51:03
Subject: Re: New hardware thoughts

From: "Carlo Stonebanks"
Date: 20 October 2006, 22:19:35
Subject: Is ODBC that slow?