ernie cline <ernie(dot)cline(at)ipgdirect(dot)com> writes:
> 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?
SELECTs certainly don't block each other (except the SELECT FOR UPDATE
variety).
> We are experiencing some performance
> problems when running 2 programs that access the database at once (only
> doing querys, and not even complex ones).
Need more detail ...
regards, tom lane