Skip site navigation (1)
Skip section navigation (2)
Title: VACUUM Performance
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 20 Oct 2006 14:42:30 -0700
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
- Re: VACUUM Performance
- Prev by Date: Re: New hardware thoughts
- Next by Date: Is ODBC that slow?
- Previous by thread: Best COPY Performance
- Next by thread: Re: VACUUM Performance
- Indexes: