Re: Slow update with simple query - Mailing list pgsql-performance

From Tom Lane
Subject Re: Slow update with simple query
Date
Msg-id 10219.1166035636@sss.pgh.pa.us
Whole thread Raw
In response to Re: Slow update with simple query  (Mark Lewis <mark.lewis@mir3.com>)
List pgsql-performance
Mark Lewis <mark.lewis@mir3.com> writes:
> But he's using 8.1.4-- in that version, an explain analyze would list
> the time taken to go through triggers, so the fact that we don't see any
> of those lines means that it can't be constraint checking, so wouldn't
> it have to be the index update overhead?

Well, it can't be foreign key checking.  Could have been an expensive
function in a CHECK constraint, maybe...

            regards, tom lane

pgsql-performance by date:

Previous
From: Ron
Date:
Subject: Re: New to PostgreSQL, performance considerations
Next
From: "Bucky Jordan"
Date:
Subject: Re: New to PostgreSQL, performance considerations