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
