Skip site navigation (1) Skip section navigation (2)

Re: set autovacuum=off

From: Filippos Kalamidas <filippos(dot)kal(at)gmail(dot)com>
To: Alessandro Gagliardi <alessandro(at)path(dot)com>
Cc: Peter van Hardenberg <pvh(at)heroku(dot)com>, Andy Colson <andy(at)squeakycode(dot)net>, pgsql-performance(at)postgresql(dot)org
Subject: Re: set autovacuum=off
Date: 2012-02-27 21:55:14
Message-ID: CANUP4k13Lqc5HfsEMGaZKsycNxwJ4A5YW4OBC2tLycjY=DwXGQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
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
<alessandro(at)path(dot)com>wrote:

> 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

Responses

pgsql-performance by date

Next:From: Filippos KalamidasDate: 2012-02-27 21:59:56
Subject: Re: set autovacuum=off
Previous:From: Scott MarloweDate: 2012-02-27 21:28:33
Subject: Re: Very long deletion time on a 200 GB database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group