[PERFORM] Reg: Slow query

2013-03-27 Thread Prakash Chinnakannan
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 outp

Re: [PERFORM] Reg: Slow query

2013-03-27 Thread Vasilis Ventirozos
Hello, This definitively doesn't look like something that has to do with postgres settings, can you show us the statement and the explain plan ? Also , have you checked pg_stat_activity to monitor what is running at the same time when the delay occurs ? It kinda looks like a lock to me. Vasilis Ve

Re: [PERFORM] 9.2.3 upgrade reduced pgbench performance by 60%

2013-03-27 Thread Josh Berkus
> > I saw some similar results comparing 9.0 and 9.2 pgbench tests. My tests > were on a VM, but on a dedicate host/hardware with no other VM's running on > it to minimize variables. I didn't have a lot of time to dig into it, but I > do recall seeing more lock contention on updates on the 9.