Re: Query performance inconsistant.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: Matthew Schumacher <matt(dot)s(at)aptalaska(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Query performance inconsistant.
Date: 2006-08-31 19:51:18
Message-ID: 23189.1157053878@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jeff Davis <pgsql(at)j-davis(dot)com> writes:
> From what you described, I would not expect many locking problems. Are
> there any other types of queries you run that may cause a lock?

Row locks (SELECT FOR UPDATE/SHARE) are a possible problem, particularly
if this is a pre-8.1 Postgres where exclusive row locks were used for
foreign key constraints.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Browne 2006-08-31 19:59:05 Re: Thought provoking piece on NetBSD
Previous Message Matthew Schumacher 2006-08-31 19:38:38 Re: Query performance inconsistant.