Re: Select for update with offset interferes with concurrent transactions

From: Andy Colson <andy(at)squeakycode(dot)net>
To: "Yngve N(dot) Pettersen (Developer Opera Software ASA)" <yngve(at)opera(dot)com>
Cc: David Johnston <polobo(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Select for update with offset interferes with concurrent transactions
Date: 2011-03-14 16:24:27
Message-ID: 4D7E413B.4010903@squeakycode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Pyhalov 2011-03-14 16:27:46 Re: Autocommit off - commits/rollbacks
Previous Message Jo 2011-03-14 16:04:50 Re: Postgres 8.3 vs. 8.4 - Query plans and performance