PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

Follow these steps to test concurrent index creation:

1. Connect to the pgbench database and execute the following command as a superuser or the postgres user:

CREATE INDEX CONCURRENTLY idx_account_bid 
    ON pgbench_accounts (bid); 

2. In another connection, attempt to execute the following INSERT command before the preceding command completes:

INSERT INTO pgbench_accounts 
VALUES (50000000, 100, 15000, 'testing');