| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | "Mkrtchyan, Tigran" <tigran(dot)mkrtchyan(at)desy(dot)de>, pgsql-performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: 9.5alpha1 vs 9.4 |
| Date: | 2015-07-05 14:33:25 |
| Message-ID: | 10845.1436106805@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Andres Freund <andres(at)anarazel(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Sabino Mullane | 2015-07-05 14:47:20 | Re: pgbouncer issue |
| Previous Message | Andres Freund | 2015-07-05 12:54:03 | Re: 9.5alpha1 vs 9.4 |