On Fri, Feb 24, 2012 at 12:54 AM, Alessandro Gagliardi <alessandro@xxxxxxxx> wrote:
On Thu, Feb 23, 2012 at 1:11 PM, Peter van Hardenberg <pvh@xxxxxxxxxx> wrote:
My hunch is still that your issue is lock contention.
How would I check that? I tried looking at pg_locks but I don't know what to look for.We have many customers who do much more than this throughput, thoughI'm not sure what level of resourcing you're current at. You might
consider experimenting with a larger system if you're having
performance problems.
Heh. I thought you might say that. :) It's definitely worth considering, but as youmight expect, I want to exhaust other options first. For customers who do much more (or even comparable) throughput, can you tell me how big of a system they require?
Also, as per Andy's suggestion, I'd like to try doubling checkpoint_segments. However, it appears that that is one of those variables that I cannot change from pgAdmin. I don't suppose there's any way to change this without rebooting the database?
