NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit23ce748

committed

Remove expensive test of postgres_fdw batch inserts

The test inserted 70k rows into a foreign table, in order to verifycorrect behavior with more than 65535 parameters, and was added inresponse to a bug report.However, this is rather expensive, especially when running the testsunder valgrind, CLOBBER_CACHE_ALWAYS etc. It doesn't seem worth it tokeep running the test, so remove it from all branches (14+).Backpatch-through: 14Discussion:https://postgr.es/m/2131017.1623451468@sss.pgh.pa.us

1 parent86f23d9 commit23ce748Copy full SHA for 23ce748

File tree

2 files changed

-18

lines changed

contrib/postgres_fdw
- expected
  - postgres_fdw.out
- sql
  - postgres_fdw.sql

2 files changed

-18

lines changed

`‎contrib/postgres_fdw/expected/postgres_fdw.out`

Lines changed: 0 additions & 11 deletions

Original file line number	Diff line number	Diff line change
`@@ -10139,17 +10139,6 @@ SELECT COUNT(*) FROM ftable;`
`10139`	`10139`	`34`
`10140`	`10140`	`(1 row)`
`10141`	`10141`
`10142`		`-TRUNCATE batch_table;`
`10143`		`-DROP FOREIGN TABLE ftable;`
`10144`		`--- try if large batches exceed max number of bind parameters`
`10145`		`-CREATE FOREIGN TABLE ftable ( x int ) SERVER loopback OPTIONS ( table_name 'batch_table', batch_size '100000' );`
`10146`		`-INSERT INTO ftable SELECT * FROM generate_series(1, 70000) i;`
`10147`		`-SELECT COUNT(*) FROM ftable;`
`10148`		`- count`
`10149`		`--------`
`10150`		`- 70000`
`10151`		`-(1 row)`
`10152`		`-`
`10153`	`10142`	`TRUNCATE batch_table;`
`10154`	`10143`	`DROP FOREIGN TABLE ftable;`
`10155`	`10144`	`-- Disable batch insert`

`‎contrib/postgres_fdw/sql/postgres_fdw.sql`

Lines changed: 0 additions & 7 deletions

Original file line number	Diff line number	Diff line change
`@@ -3181,13 +3181,6 @@ SELECT COUNT(*) FROM ftable;`
`3181`	`3181`	`TRUNCATE batch_table;`
`3182`	`3182`	`DROP FOREIGN TABLE ftable;`
`3183`	`3183`
`3184`		`--- try if large batches exceed max number of bind parameters`
`3185`		`-CREATE FOREIGN TABLE ftable ( xint ) SERVER loopback OPTIONS ( table_name'batch_table', batch_size'100000' );`
`3186`		`-INSERT INTO ftableSELECT*FROM generate_series(1,70000) i;`
`3187`		`-SELECTCOUNT(*)FROM ftable;`
`3188`		`-TRUNCATE batch_table;`
`3189`		`-DROP FOREIGN TABLE ftable;`
`3190`		`-`
`3191`	`3184`	`-- Disable batch insert`
`3192`	`3185`	`CREATE FOREIGN TABLE ftable ( xint ) SERVER loopback OPTIONS ( table_name'batch_table', batch_size'1' );`
`3193`	`3186`	`EXPLAIN (VERBOSE, COSTS OFF)INSERT INTO ftableVALUES (1), (2);`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit23ce748

File tree

2 files changed

2 files changed

`‎contrib/postgres_fdw/expected/postgres_fdw.out`

`‎contrib/postgres_fdw/sql/postgres_fdw.sql`

0 commit comments