Hi all, Currently, I'm working on a performance issue with a query which takes around ~30 sec to complete. This happens only, when there are more activity going around same table. The same query completes with in a second when there are no activity on that table. Tried taking EXPLAIN ANALYZE output and analyze it, since it completes with in a second, there are no blockers in it. Is there any way to see whether postgress settings creates the problem? which could be related to memory, locks or I/O etc.. Thanks for your help. --Prakash -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
