From: | Wes <wespvp(at)syntegra(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Postgresql-General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Vacuum time degrading |
Date: | 2005-04-04 15:38:56 |
Message-ID: | BE76BBB0.9E2F%wespvp@syntegra.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
On 3/2/05 10:50 PM, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> It wouldn't be easy --- there are some locking considerations that say
> btbulkdelete needs to scan the index in the same order that an ordinary
> scan would do. See the nbtree README for details.
Just a follow-up on this..
The vacuum time has been steadily increasing at a seemingly increasing rate,
although there are no deletes or updates to the database. The current DB
size is just over 500 million rows. Last week it was up to 6.84 hours to do
a vacuum. Over the weekend I reindexed all the major indexes. The two
largest indexes took about 10 hours to reindex both. After the reindexing,
the vacuum took only 1.44 hours. This is pretty much a linear scaling from
the original vacuum time I reported.
So, the increasing vacuum times would appear to be as Tom suggested - due to
the fact that vacuum processes indexes in index order, not physical disk
order. I guess we add a periodic reindex to our maintenance procedures...
Wes
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas F.O'Connell | 2005-04-04 16:00:28 | Re: Recovering real disk space |
Previous Message | Tom Lane | 2005-04-04 15:36:24 | Re: invalid input syntax for type bytea |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-04-04 15:42:33 | Re: DELETE ... USING |
Previous Message | Andrew Dunstan | 2005-04-04 15:36:10 | Re: [HACKERS] plPHP in core? |