Re: btbulkdelete

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: btbulkdelete
Date: 2004-04-26 16:24:04
Message-ID: 1gdq80pgoj3c6a0nt11sesd05k7ntp0jep@email.aon.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, 26 Apr 2004 14:29:58 +0100, Simon Riggs <simon(at)2ndquadrant(dot)com>
wrote:
>> Now that FSM
>> covers free btree index pages this access pattern might be highly
>> nonsequential.
>
>I had considered implementing a mode where the index doesn't keep trying
>to reuse space that was freed by earlier deletes.

Or maybe an FSM function a la "Give me a free page near this one"?

Servus
Manfred

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2004-04-26 16:48:40 Re: PITR Phase 1 - Test results
Previous Message Merlin Moncure 2004-04-26 15:37:37 Re: FW: getting a crash during initdb