Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group