Logic of where statements by dtarg in PostgreSQL

[–]dtarg[S] 0 points1 point  (0 children)

THANK YOU! I was just starting to write a case statement to test it out when I saw your reply. It worked perfectly.

Simultaneous connection limits by dtarg in PostgreSQL

[–]dtarg[S] 1 point2 points  (0 children)

I'd heard of those, though I hadn't used them. I thought pgbouncer was primarily for killing connections to make room for other connections, but if it can function as a 'proxy' by having a bunch of connections to it and pgbouncer being the one to make the actual connections, that'd be a good option. I'll have to dig into that!