Re: Slow response of PostgreSQL - Mailing list pgsql-performance

From Neil Conway
Subject Re: Slow response of PostgreSQL
Date
Msg-id 87d689es5k.fsf@mailbox.samurai.com
Whole thread Raw
In response to Re: Slow response of PostgreSQL  (Shridhar Daithankar <shridhar@frodo.hserus.net>)
List pgsql-performance
Shridhar Daithankar <shridhar@frodo.hserus.net> writes:
> Right now, it is hotly debated on HACKERS about adding a NOWAIT
> clause to SELECT FOR UPDATE. If you think your application
> deployment is away for months and can try CVS head, you can expect
> some action on it in coming few days.

You can also try using the statement_timeout configuration variable
that is already included with 7.4. It's not exactly "don't wait for
locks", but should approximate that behavior well enough.

http://www.postgresql.org/docs/7.4/static/runtime-config.html#RUNTIME-CONFIG-CLIENT

-Neil


pgsql-performance by date:

Previous
From: Bill Moran
Date:
Subject: Re: Slow in morning hours
Next
From: ohp@pyrenet.fr
Date:
Subject: Re: Slow in morning hours