Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group