Re: LP_DEAD hinting and not holding on to a buffer pin on leaf page(Was: [HACKERS] [WIP] Zipfian distribution in pgbench)
От
Peter Geoghegan
Тема
Re: LP_DEAD hinting and not holding on to a buffer pin on leaf page(Was: [HACKERS] [WIP] Zipfian distribution in pgbench)
Дата
Msg-id
CAH2-Wzn_XCLb--9_woC=-GANPZchhw1K7wwmyQE5Y8vOWWrShw@mail.gmail.com
Ответ на
Re: LP_DEAD hinting and not holding on to a buffer pin on leaf page(Was: [HACKERS] [WIP] Zipfian distribution in pgbench) (Peter Geoghegan)
Список
Дерево обсуждения
Re: LP_DEAD hinting and not holding on to a buffer pin on leaf page(Was: [HACKERS] [WIP] Zipfian distribution in pgbench) Amit Kapila <amit.kapila16@gmail.com>
Re: LP_DEAD hinting and not holding on to a buffer pin on leaf page(Was: [HACKERS] [WIP] Zipfian distribution in pgbench) Robert Haas <robertmhaas@gmail.com>
Re: LP_DEAD hinting and not holding on to a buffer pin on leaf page(Was: [HACKERS] [WIP] Zipfian distribution in pgbench) Robert Haas <robertmhaas@gmail.com>
Re: LP_DEAD hinting and not holding on to a buffer pin on leaf page(Was: [HACKERS] [WIP] Zipfian distribution in pgbench) Robert Haas <robertmhaas@gmail.com>
Re: LP_DEAD hinting and not holding on to a buffer pin on leaf page(Was: [HACKERS] [WIP] Zipfian distribution in pgbench) Peter Geoghegan <pg@bowt.ie>
On Tue, Jul 25, 2017 at 8:02 PM, Peter Geoghegan wrote: > Setup: > > Initialize pgbench (any scale factor). > create index on pgbench_accounts (aid); That "create index" was meant to be on "abalance", to make the UPDATE queries always HOT-unsafe. (You'll want to *also* create this index once the PK is dropped, to show how killing items on recent Postgres versions hinges upon this being a unique index). -- Peter Geoghegan
В списке pgsql-hackers по дате отправления
От: Peter Geoghegan
Дата: