Andres Freund <andres@xxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
