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
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
>
> 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.