Re: Vacuum time degrading - Mailing list pgsql-general

From Tom Lane
Subject Re: Vacuum time degrading
Date
Msg-id 17057.1109825404@sss.pgh.pa.us
Whole thread Raw
In response to Vacuum time degrading  (Wes <wespvp@syntegra.com>)
Responses Re: Vacuum time degrading  (Wes <wespvp@syntegra.com>)
Re: Vacuum time degrading  (Wes <wespvp@syntegra.com>)
List pgsql-general
Wes Palmer <Wesley.R.Palmer@syntegra.com> writes:
> Any chance of change that
> behavior to scan in physical storage order?

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.

            regards, tom lane

pgsql-general by date:

Previous
From: "Guy Rouillier"
Date:
Subject: Re: pgadmin3 / postgresql newbie question
Next
From: jack alex
Date:
Subject: does postgres supports syslog-ng package for loging rather than using standart syslog package