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.
