Skip site navigation (1) Skip section navigation (2)

Re: Slow response of PostgreSQL

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Bill Moran <wmoran(at)potentialtech(dot)com>
Cc: Saleem Burhani Baloch <peseek(at)khi(dot)wol(dot)net(dot)pk>,pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow response of PostgreSQL
Date: 2004-02-18 01:50:00
Message-ID: 4032C4C8.2090200@familyhealth.com.au (view raw or flat)
Thread:
Lists: pgsql-performance
>>> 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


In response to

Responses

pgsql-performance by date

Next:From: scott.marloweDate: 2004-02-18 01:50:08
Subject: Re: Slow response of PostgreSQL
Previous:From: Tom LaneDate: 2004-02-17 23:55:42
Subject: Re: long running query running too long

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group