Re: Limit I/O bandwidth of a certain backend

From: Bryan Murphy <bmurphy1976(at)gmail(dot)com>
To: Vlad Arkhipov <arhipov(at)dc(dot)baikal(dot)ru>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Limit I/O bandwidth of a certain backend
Date: 2009-05-06 00:54:00
Message-ID: 7fd310d10905051754k61e602e1i354285e31391c03c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, May 5, 2009 at 2:31 AM, Vlad Arkhipov <arhipov(at)dc(dot)baikal(dot)ru> wrote:
> Is there a way to limit I/O bandwidth/CPU usage of a certain backend? It
> seems that ionice/renice makes no sense because of bgwriter/WAL writer
> processes are not a part of a backend. I have a periodic query (every
> hour) that make huge I/O load and should run in background. When this
> query runs all other fast queries slow down dramatically.

Could you use something like slony to replicate the needed data to a
secondary database and run the query there?

Bryan

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2009-05-06 05:10:53 Re: Limit I/O bandwidth of a certain backend
Previous Message Matthew Wakeling 2009-05-05 11:24:42 Re: [HACKERS] high shared buffer and swap