Reg: Slow query

From: Prakash Chinnakannan <prakash(dot)chinnakannan(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Reg: Slow query
Date: 2013-03-27 14:04:53
Message-ID: CACDAp1BJ1LVReNpfFaa6vD8i6e4-sPkO+y9+gd8HLYDpyJMPMw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Vasilis Ventirozos 2013-03-27 14:15:30 Re: Reg: Slow query
Previous Message Nicholson, Brad (Toronto, ON, CA) 2013-03-26 20:05:39 Re: 9.2.3 upgrade reduced pgbench performance by 60%