4 ms·
Having used schema based sharding in postgres before, I hope citus has a way around connection pooling and pgbouncer, as if you use pgbouncer transaction poolin
by skunkworker 3y ago
Having used schema based sharding in postgres before, I hope citus has a way around connection pooling and pgbouncer, as if you use pgbouncer transaction pooling your search_path could disappear at any time.
- mulander 3y agoGreat observation! :) We worked upstream to have `search_path` properly handled (tracked per client) by pgbouncer. https://github.com/pgbouncer/pgbouncer/commit/8c18fc4d213ad425841434767b71616dc3386102 https://github.com/pgbouncer/pgbouncer/commit/8c18fc4d213ad4... Check config.md in that commit for a verbose, humanized description.
- deleted 3y ago[deleted]