VACUUM Performance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: <pgsql-performance@xxxxxxxxxxxxxx>
Subject: VACUUM Performance
From: "Steve Oualline" <soualline@xxxxxxxxxxxxx>
Date: Fri, 20 Oct 2006 14:42:30 -0700
Cc: "Jiu Zheng" <Jiu@xxxxxxxxxxxxx>
Thread-index: Acb0kKR1AI7NHDE6RkCPPOzTIG48rA==
Thread-topic: VACUUM Performance

Title: VACUUM 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?

Follow-Ups:
- Re: VACUUM Performance
  - From: Tom Lane

Prev by Date: [no subject]
Next by Date: Is ODBC that slow?
Previous by thread: [no subject]
Next by thread: Re: VACUUM Performance
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux