load_all_buffers.sql

text/plain

Filename: load_all_buffers.sql

Type: text/plain

Part: 3

Message: Re: [WIP PATCH] for Performance Improvement in Buffer Management

create extension pg_prewarm;

select pg_prewarm('pgbench_accounts', 'main', 'read', NULL, NULL);
select pg_prewarm('pgbench_branches', 'main', 'read', NULL, NULL);
select pg_prewarm('pgbench_tellers', 'main', 'read', NULL, NULL);
select pg_prewarm('pgbench_accounts_pkey', 'main', 'read', NULL, NULL);
select pg_prewarm('pgbench_branches_pkey', 'main', 'read', NULL, NULL);
select pg_prewarm('pgbench_tellers_pkey', 'main', 'read', NULL, NULL);

select pg_prewarm('pgbench_accounts', 'main', 'buffer', NULL, NULL);
select pg_prewarm('pgbench_branches', 'main', 'buffer', NULL, NULL);
select pg_prewarm('pgbench_tellers', 'main', 'buffer', NULL, NULL);
select pg_prewarm('pgbench_accounts_pkey', 'main', 'buffer', NULL, NULL);
select pg_prewarm('pgbench_branches_pkey', 'main', 'buffer', NULL, NULL);
select pg_prewarm('pgbench_tellers_pkey', 'main', 'buffer', NULL, NULL);