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: (view raw or whole 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?


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-2015 The PostgreSQL Global Development Group