[Tile-serving] [osm2pgsql-dev/osm2pgsql] High connection volume to Postgres (Discussion #1650)

[Ryan Lambert]

Exciting news, pgbouncer recently merged support for prepared statements. PR https://github.com/pgbouncer/pgbouncer/pull/845, the changes to documentation includes:

> "When this is set to a non-zero value PgBouncer tracks protocol-level named
> prepared statements related commands sent by the client in transaction and
> statement pooling mode. PgBouncer makes sure that any statement prepared by
> a client is available on the backing server connection. Even when the statement
> was originally prepared on another server connection."

I originally was blocked trying to use pgbouncer by prepared statements in transaction mode.  This should remove that roadblock.  I'll hopefully find time to do some testing with that again before long.

-- 
Reply to this email directly or view it on GitHub:
https://github.com/osm2pgsql-dev/osm2pgsql/discussions/1650#discussioncomment-7281306
You are receiving this because you are subscribed to this thread.

Message ID: <osm2pgsql-dev/osm2pgsql/repo-discussions/1650/comments/7281306 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20231014/8667df27/attachment.htm>