Content-Length: 238888 | pFad | http://github.com/postgrespro/postgres_cluster/commit/4e7ecc781f06fe01a2060145322a87ec250c184c

5E Associate WaitEventSet with postgres_fdw connection. · postgrespro/postgres_cluster@4e7ecc7 · GitHub
Skip to content

Commit 4e7ecc7

Browse files
arssherarssher
committed
Associate WaitEventSet with postgres_fdw connection.
Instead of epoll_create/close every single time we wait for foreign server in pgfdw_get_result, reuse WaitEventSet during the lifetime of the connection, removing this bottleneck. We have to pass around ConnCacheEntry around instead of plain pq connection for that, so changes are not that small. On the other hand, probably we can reuse this state for session-level prepared statements support. Another solution would be internal caching of epoll instances in latch.c, however that's much more invasive and it is not entirely clear when to invalidate such cache. We also should probably check other uses WaitLatch/WaitLatchOrSocket for such bottlenecks.
1 parent 7179ae0 commit 4e7ecc7

File tree

3 files changed

+213
-145
lines changed

3 files changed

+213
-145
lines changed

0 commit comments

Comments
 (0)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres_cluster/commit/4e7ecc781f06fe01a2060145322a87ec250c184c

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy