On 07/11/2012 07:40 PM, Yan Chunlu wrote:
> could that because of my system is really busy?
> 1, postgresql always have 400+ connections(dozens of python process
> using client pool)
> 2, the query peak is 50+/s
> 3, I do have some bad performance sql executing periodically, need
> 100+ second to complete. could those bad performance sql influence
> others? because when I execute those simple sql directly, they was
> fast. but the slow query log shows it took too much time.
>
Oh, come on, these are the sorts of things you tell us /when you ask
your question/, not days later after lots of back-and-forth discussion.
--
Craig Ringer