Re: performance question - Mailing list pgsql-general

From Manuel Sugawara
Subject Re: performance question
Date
Msg-id m38zv5rfow.fsf@dep1.fciencias.unam.mx
Whole thread Raw
In response to performance question  (ernie cline <ernie.cline@ipgdirect.com>)
List pgsql-general
ernie cline <ernie.cline@ipgdirect.com> writes:

> Hello all,
> Quick question.  I am using postgres 7.0.  When running a select query,
> does postgres lock the row (or table) while doing a select?  Only on an
> insert/update/delete, right?  We are experiencing some performance

Each SELECT is done inside a transaction. Otherwise you cannot ensure
consistent snapshots.

Manuel.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: performance question
Next
From: Joseph Shraibman
Date:
Subject: Re: select for update not locking properly.