Postgres Pro
Downloads
Home   >   mailing lists

Re: Planner performance extremely affected by an hanging transaction (20-30 times)? - Mailing list pgsql-performance

From Bartłomiej Romański
Subject Re: Planner performance extremely affected by an hanging transaction (20-30 times)?
Date
Msg-id CAC6=Lj50WW2y3VBNHJ9PJm5KmD_Ter=EJO2JXPX7mUm_TFZZQw@mail.gmail.com
Whole thread Raw
List pgsql-performance
Tree view
> What's more doing similar insert (even much larger) to the 'offers' table does not affect the benchmark results in any significant way...

Just want clarify myself here: Insert to 'offers' table does not cause the slowdown. Only insert to 'categories' causes the problem.

pgsql-performance by date:

Previous
From: Andres Freund
Date:
Subject: Re: Cpu usage 100% on slave. s_lock problem.
Next
From: Александр Белинский
Date:
Subject: Re: function execute on v.9.2 slow down