Resources

PostgreSQL Extension Connection Pool

duckdb.org

PostgreSQL server spawns a backend process for every incoming client connection. This model leads to the two following points with the postgres extension that can cause performance problems: opening a new connection is relatively expensive the number of the connections opened at the same time should not be too high To deal with these points the extensions uses an in-memory connection pool. With it a limited number o…

Visit Site

Resources duckdb.org