| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Y W <luckyasser(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Transaction settings: nowait |
| Date: | 2009-05-29 17:02:08 |
| Message-ID: | dcc563d10905291002t668478dy2887827b7d0d1e2e@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, May 29, 2009 at 10:55 AM, Y W <luckyasser(at)gmail(dot)com> wrote:
> But according to the documentation, are they ignored if postgres was hosted
> on a Unix/linux system?
They work fine on unix, as long as the user has the option to set
their own timeouts. If not then set them for the OS (for linux see
/etc/sysctl.conf)
> And are you're pretty sure that connections are terminated on the server
> side, which will result in releasing any locked resources during that failed
> transaction?
Yep, tested and confirmed behaviour on RHEL4 and RHEL5 in production.
I set the system level tcp_keepalive setttings in those two instances.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2009-05-29 17:02:44 | Re: Transaction settings: nowait |
| Previous Message | Tom Lane | 2009-05-29 16:56:48 | Re: Converting each item in array to a query result row |