Re: performance question

From: Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx>
To: ernie cline <ernie(dot)cline(at)ipgdirect(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: performance question
Date: 2000-07-13 19:30:23
Message-ID: m38zv5rfow.fsf@dep1.fciencias.unam.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

ernie cline <ernie(dot)cline(at)ipgdirect(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-07-13 20:11:48 Re: performance question
Previous Message John 2000-07-13 19:23:35 Re: performance question