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
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
In response to
pgsql-hackers by date
|Next:||From: Simon Riggs||Date: 2006-02-28 13:22:35|
|Subject: Re: Vacuum dead tuples that are "between" transactions|
|Previous:||From: Andreas Pflug||Date: 2006-02-28 13:14:01|
|Subject: Re: new feature: LDAP database name resolution|