Andres Freund <and...@anarazel.de> writes:
> On 2015-07-05 13:10:51 +0200, Mkrtchyan, Tigran wrote:
>> today I have update my test system to 9.5alpha1.
>> Most of the operations are ok, except delete.
>> I get ~1000 times slower!
>> 255.88 | 566.11 | 452 | DELETE FROM t_inodes WHERE ipnfsid=$1 AND
>> inlink = ?
> That certainly should not be the case. Could you show the query plan for
> this statement in both versions?
EXPLAIN ANALYZE, please. I'm wondering about a missing index on some
foreign-key-involved column. That would show up as excessive time in
the relevant trigger ...
regards, tom lane
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
