yup there is. the parameter checkpoint_segments does not require a restart
of the server, just a reload :)
On Fri, Feb 24, 2012 at 12:54 AM, Alessandro Gagliardi
> On Thu, Feb 23, 2012 at 1:11 PM, Peter van Hardenberg <pvh(at)heroku(dot)com>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, though
>> I'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?
In response to
pgsql-performance by date
|Next:||From: Filippos Kalamidas||Date: 2012-02-27 21:59:56|
|Subject: Re: set autovacuum=off|
|Previous:||From: Scott Marlowe||Date: 2012-02-27 21:28:33|
|Subject: Re: Very long deletion time on a 200 GB database|