On Tue, Jul 25, 2017 at 8:02 PM, Peter Geoghegan <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
