performance question - Mailing list pgsql-general

From ernie cline
Subject performance question
Date
Msg-id 396E05EF.C349C15E@ipgdirect.com
Whole thread Raw
Responses Re: performance question
List pgsql-general
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
problems when running 2 programs that access the database at once (only
doing querys, and not even complex ones).

-ernie

pgsql-general by date:

Previous
From: Ed Loehr
Date:
Subject: location of change list?
Next
From: Joseph Shraibman
Date:
Subject: Re: select for update not locking properly.