On Tue, Jul 25, 2017 at 8:02 PM, Peter Geoghegan <p...@bowt.ie> 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
