Re: Slow response of PostgreSQL

From: Bill Moran <wmoran(at)potentialtech(dot)com>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
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-17 13:02:51
Message-ID: 403210FB.5040209@potentialtech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Christopher Kings-Lynne wrote:
>> 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?

--
Bill Moran
Potential Technologies
http://www.potentialtech.com

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Huxton 2004-02-17 14:56:02 Re: Tables on multiple disk drives
Previous Message Konstantin Tokar 2004-02-17 12:54:54 Tables on multiple disk drives