| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | SF Postgres <sfpug(at)postgresql(dot)org> |
| Subject: | The uselessness of pgbouncer PAUSE |
| Date: | 2014-01-16 00:08:50 |
| Message-ID: | 52D72312.4040202@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | sfpug |
Sergey,
I looked into this today, and it doesn't help at all. PAUSE will wait
for all current queries to complete before switching over, which isn't
tolerable in a failover situation. Unfortunately, there seems to be no
command which says "kill running query connections but leave idle
connections alone". Possible this is the idea behind SUSPEND, but if
so, it doesn't work.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2014-01-16 00:16:24 | Re: Creating a custom email token parser for FTS |
| Previous Message | Brian Ghidinelli | 2014-01-15 02:09:42 | Creating a custom email token parser for FTS |