5 ms·
Scalable in which sense? Assuming that this is something like pgbouncer or pgpool that sit between the client and the database, and that you have a limit of co
by tuldia 7y ago
Scalable in which sense?
Assuming that this is something like pgbouncer or pgpool that sit between the client and the database, and that you have a limit of connections with the database as well as the number of client connections you can keep, what value does this adds compared with those other (more mature, battle tested, included in major distros) projects?
- x4m 7y agoPgbouncer is single-threaded. If you have 80-core box it is a huge waste to terminate your SSL in single-threaded proxy pooler.
- takeda 7y agoStarting from version 1.12.0 you can actually run multiple pgbouncer processes listening on the same port, that eliminates some of the issues.
- x4m 7y agoYes, we use a cascade of PgBouncers. But it's hard to maintain, actually. Also, PgBouncer was not actively developed for years. I consider new PgBouncer features (port reuse, SCRAM-SHA-256) accomplishment of Odyssey to some (small) extent :)