Re: Dead Space Map

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Hannu Krosing <hannu(at)skype(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Dead Space Map
Date: 2006-02-28 13:16:10
Message-ID: 20060228131610.GF4425@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hannu Krosing wrote:

> In the "big table with hotspots" case, I doubt that the win from
> btbulkdelete will outweight having to scan 100000 index pages to get to
> the 30 or 50 that can be bulkdeleted.

Remember that WAL traffic is fsync'ed, so it can be _much_ slower than
anything else.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2006-02-28 13:22:35 Re: Vacuum dead tuples that are "between" transactions
Previous Message Andreas Pflug 2006-02-28 13:14:01 Re: new feature: LDAP database name resolution