Re: Random performance hit, unknown cause.

From: Claudio Freire <klaussfreire(at)gmail(dot)com>
To: Brian Fehrle <brianf(at)consistentstate(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Random performance hit, unknown cause.
Date: 2012-04-12 19:59:10
Message-ID: CAGTBQpb-jBxksVQ4MFjjSELY2428zNkgTZXLqrj+QmezFzA4MA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Apr 12, 2012 at 3:41 PM, Brian Fehrle
<brianf(at)consistentstate(dot)com> wrote:
> Is there anything that can help us maximise the performance to disk in this
> case, as it seems to be one of our major bottlenecks?

If it's indeed autovacuum, like I think it is, you can try limiting it
with pg's autovacuum_cost_delay params.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Brian Fehrle 2012-04-12 21:31:21 Re: Random performance hit, unknown cause.
Previous Message Kevin Grittner 2012-04-12 19:52:11 Re: Random performance hit, unknown cause.