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

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 (view raw or flat)
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

pgsql-performance by date

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

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