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 4032C4C8.2090200@familyhealth.com.au
Whole thread Raw
In response to Re: Slow response of PostgreSQL  (Bill Moran <wmoran@potentialtech.com>)
Responses Re: Slow response of PostgreSQL  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-performance
Tree view 
>>> 1- How can I lock a single record so that other users can only read
>>> it. ??
>>
>>
>> You cannot do that in PostgreSQL.
>
>
> How about SELECT ... FOR UPDATE?

No, because users cannot read the locked row in that case.

Chris

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: long running query running too long
Next
From: "scott.marlowe"
Date:
Subject: Re: Slow response of PostgreSQL