fdw_limit.sql

text/plain

Filename: fdw_limit.sql

Type: text/plain

Part: 0

Message: Re: Problems with plan estimates in postgres_fdw

create extension postgres_fdw ;
create server foo foreign data wrapper postgres_fdw options (use_remote_estimate  'true', fetch_size '100000');
\! pgbench -i -s20 foo
create user MAPPING FOR public SERVER foo ;
create schema schema2;
import FOREIGN SCHEMA public from server foo into schema2;
explain (verbose,analyze) select * from schema2.pgbench_accounts limit 1;