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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-performance@xxxxxxxxxxxxxx
Subject: Re: Planner performance extremely affected by an hanging transaction (20-30 times)?
From: Bartłomiej Romański <br@xxxxxxxxx>
Date: Wed, 18 Sep 2013 00:16:49 +0200
In-reply-to: <CAC6=Lj5SDdCc8OW-TLJJTNUCx5PzoMdSBHFAQ9uGYBfG+95RFA@mail.gmail.com>

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

Prev by Date: Re: Cpu usage 100% on slave. s_lock problem.
Next by Date: Re: function execute on v.9.2 slow down
Previous by thread: How to optimization database for heavy I/O from updates (software and hardware)
Next by thread: Planner performance extremely affected by an hanging transaction (20-30 times)?
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux