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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
