Re: Vacuum time degrading

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Wes Palmer <Wesley(dot)R(dot)Palmer(at)syntegra(dot)com>
Cc: Postgresql-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Vacuum time degrading
Date: 2005-03-03 04:50:04
Message-ID: 17057.1109825404@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Wes Palmer <Wesley(dot)R(dot)Palmer(at)syntegra(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message jack alex 2005-03-03 06:44:37 does postgres supports syslog-ng package for loging rather than using standart syslog package
Previous Message Wes Palmer 2005-03-03 04:46:48 Re: Vacuum time degrading

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2005-03-03 05:20:35 Re: [HACKERS] UTF8 or Unicode
Previous Message Wes Palmer 2005-03-03 04:46:48 Re: Vacuum time degrading