NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit0ec5306

committed

Fix performance regression in dblink connection speed.

Previous commite5de601 modified dblinkto ensure client encoding matched the server. However the addedPQsetClientEncoding() call added significant overhead. Restore originalperformance in the common case where client encoding already matchesserver encoding by doing nothing in that case. Applies to all activebranches.Issue reported and work sponsored by Zonar Systems.

1 parent2dcc48c commit0ec5306Copy full SHA for 0ec5306

File tree

1 file changed

-3

lines changed

contrib/dblink
- dblink.c

1 file changed

-3

lines changed

`‎contrib/dblink/dblink.c`

Lines changed: 5 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -209,7 +209,8 @@ typedef struct remoteConnHashEnt`
`209`	`209`	`errdetail_internal("%s", msg))); \`
`210`	`210`	`} \`
`211`	`211`	`dblink_security_check(conn, rconn); \`
`212`		`-PQsetClientEncoding(conn, GetDatabaseEncodingName()); \`
	`212`	`+if (PQclientEncoding(conn) != GetDatabaseEncoding()) \`
	`213`	`+PQsetClientEncoding(conn, GetDatabaseEncodingName()); \`
`213`	`214`	`freeconn = true; \`
`214`	`215`	`} \`
`215`	`216`	`} while (0)`
`@@ -288,8 +289,9 @@ dblink_connect(PG_FUNCTION_ARGS)`
`288`	`289`	`/* check password actually used if not superuser */`
`289`	`290`	`dblink_security_check(conn,rconn);`
`290`	`291`
`291`		`-/* attempt to set client encoding to match server encoding */`
`292`		`-PQsetClientEncoding(conn,GetDatabaseEncodingName());`
	`292`	`+/* attempt to set client encoding to match server encoding, if needed */`
	`293`	`+if (PQclientEncoding(conn)!=GetDatabaseEncoding())`
	`294`	`+PQsetClientEncoding(conn,GetDatabaseEncodingName());`
`293`	`295`
`294`	`296`	`if (connname)`
`295`	`297`	`{`

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!

Commit0ec5306

File tree

1 file changed

1 file changed

`‎contrib/dblink/dblink.c`

0 commit comments