Postgres Pro
Downloads
Home   >   mailing lists

Re: Select for update with offset interferes with concurrent transactions - Mailing list pgsql-general

From Andy Colson
Subject Re: Select for update with offset interferes with concurrent transactions
Date
Msg-id 4D7E413B.4010903@squeakycode.net
Whole thread Raw
In response to Re: Select for update with offset interferes with concurrent transactions  ("Yngve N. Pettersen (Developer Opera Software ASA)" <yngve@opera.com>)
List pgsql-general
Tree view 
On 3/14/2011 10:13 AM, Yngve N. Pettersen (Developer Opera Software ASA)
wrote:
> Hello all,
>
> Just a quick update of how it went.
>
> I ended up using code similar to a combination of Andy Colson's and David
> Johnston's suggestions below, and performance is back at what is was
> before. Thanks for the suggestions
>

Sweet, thanks for the update... I always like to hear how things turn out.

-Andy

pgsql-general by date:

Previous
From: Jo
Date:
Subject: Re: Postgres 8.3 vs. 8.4 - Query plans and performance
Next
From: Alexander Pyhalov
Date:
Subject: Re: Autocommit off - commits/rollbacks