Wdxs23gb

1create server if not exists localhost foreign data wrapper postgres_fdw options (host '127.0.0.1', dbname 'test');
2
3create user mapping if not exists for test server localhost options (user 'test', password 'test');
4
5create table test_table (n integer)
6
7do $$
8begin
9  for i in 1 .. 1000 loop
10    insert into test_table (n) values (1);
11    commit;
12  end loop;
13end
14$$
15--> completed in 19 ms
16
17truncate table test_table
18
19do $$
20begin
21  for i in 1 .. 1000 loop
22    perform dblink_connect('localhost');
23    perform dblink_exec('localhost', 'insert into test_table (n) values (1)', false);
24  end loop;
25end
26$$
27--> completed in 4 m 36 s 768 ms
28