Re: 9.5alpha1 vs 9.4

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 9.5alpha1 vs 9.4
Дата
Msg-id 10845.1436106805@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: 9.5alpha1 vs 9.4  (Andres Freund <andres@anarazel.de>)
Ответы Re: 9.5alpha1 vs 9.4  ("Mkrtchyan, Tigran" <tigran.mkrtchyan@desy.de>)
Список pgsql-performance
Andres Freund <andres@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


В списке pgsql-performance по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: 9.5alpha1 vs 9.4
Следующее
От: "Greg Sabino Mullane"
Дата:
Сообщение: Re: pgbouncer issue