Re: how could select id=xx so slow?

[Craig Ringer <ringerc@xxxxxxxxxxxxx>]

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