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

Re: Dead Space Map

From: Hannu Krosing <hannu(at)skype(dot)net>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
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 16:12:30
Message-ID: 1141143150.3864.3.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-hackers
Ühel kenal päeval, T, 2006-02-28 kell 10:16, kirjutas Alvaro Herrera:
> 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.

But it should need to be fsynced only once, at commit time, so if you
can clean up more than one page, you end up with many wal records, but
just one fsync.

-------------
Hannu



In response to

pgsql-hackers by date

Next:From: Jim C. NasbyDate: 2006-02-28 16:14:01
Subject: Re: Dead Space Map
Previous:From: Hannu KrosingDate: 2006-02-28 16:10:05
Subject: Re: Dead Space Map

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