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

From: Bartłomiej Romański <br(at)sentia(dot)pl>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Planner performance extremely affected by an hanging transaction (20-30 times)?
Date: 2013-09-17 22:16:49
Message-ID: CAC6=Lj50WW2y3VBNHJ9PJm5KmD_Ter=EJO2JXPX7mUm_TFZZQw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> 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.

Browse pgsql-performance by date

  From Date Subject
Next Message Andres Freund 2013-09-17 23:10:50 Re: [PERFORM] encouraging index-only scans
Previous Message Jim Nasby 2013-09-17 16:37:35 Re: [PERFORM] encouraging index-only scans