VACUUM Performance

From: "Steve Oualline" <soualline(at)stbernard(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Cc: "Jiu Zheng" <Jiu(at)stbernard(dot)com>
Subject: VACUUM Performance
Date: 2006-10-20 21:42:30
Message-ID: 00C5463E8A5F7C41A8396D701A6734B1527A62@mail01.stbernard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Carlo Stonebanks 2006-10-20 22:19:42 Is ODBC that slow?
Previous Message Ben Suffolk 2006-10-20 20:33:43 Re: New hardware thoughts