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

Re: Preventing query from hogging server

From: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
To: matt(at)followers(dot)net
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Preventing query from hogging server
Date: 2005-03-28 21:05:59
Message-ID: 20050328210559.GC51784@decibel.org (view raw or flat)
Thread:
Lists: pgsql-performance
On Thu, Mar 24, 2005 at 01:07:39PM -0600, Matthew Nuzum wrote:
> I've tried `nice psql` in the past and I don't think that had much impact,
> but I haven't tried it on this query.

On linux, nice will only help if the query is CPU-bound. On FreeBSD,
nice affects I/O scheduling, as well as CPU, so it's a more effective
means of limiting the impact of large queries. I don't know how other
OS's handle this.
-- 
Jim C. Nasby, Database Consultant               decibel(at)decibel(dot)org 
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"

In response to

pgsql-performance by date

Next:From: Simon RiggsDate: 2005-03-28 21:07:25
Subject: Re: Delete query takes exorbitant amount of time
Previous:From: Joshua D. DrakeDate: 2005-03-28 20:57:08
Subject: Re: which dual-CPU hardware/OS is fastest for PostgreSQL?

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