Postgres Pro
Downloads
Home   >   mailing lists

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

From Christopher Kings-Lynne
Subject Re: Slow response of PostgreSQL
Date
Msg-id 4032EFA7.2040106@familyhealth.com.au
Whole thread Raw
In response to Re: Slow response of PostgreSQL  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-performance
Tree view 
>>>How about SELECT ... FOR UPDATE?
>>
>>No, because users cannot read the locked row in that case.
>
>
> I just tested it (within transactions) and it appeared that I could still
> view the rows selected for update.

Ah, true.  My mistake.  OK, well you can do it in postgres then...

Chris

pgsql-performance by date:

Previous
From: Bill Moran
Date:
Subject: Re: Slow response of PostgreSQL
Next
From: Kevin Brown
Date:
Subject: Re: UPDATE with subquery too slow