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

Re: renice on an I/O bound box

From: "Ing(dot) Marcos L(dot) Ortiz Valmaseda" <mlortiz(at)uci(dot)cu>
To: Willy-Bas Loos <willybas(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: renice on an I/O bound box
Date: 2010-01-19 08:25:28
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
El 19/01/2010 13:59, Willy-Bas Loos escribió:
> Hi,
> I have a query that runs for about 16 hours, it should run at least 
> weekly.
> There are also clients connecting via a website, we don't want to keep 
> them waiting because of long DSS queries.
> We use Debian Lenny.
> I've noticed that renicing the process really lowers the load (in 
> "top"), though i think we are I/O bound. Does that make any sense?
> Cheers,
> -- 
> "Patriotism is the conviction that your country is superior to all 
> others because you were born in it." -- George Bernard Shaw
¿16 hours?
¿Which the amount of data? of 10  to 30 000 000 of records no?

¿Do you put the code here to see if we can help you on its optimization?

About the question, you can give more information with iostat.

In response to

pgsql-performance by date

Next:From: fkater@googlemail.comDate: 2010-01-19 10:16:07
Subject: Re: Inserting 8MB bytea: just 25% of disk perf used?
Previous:From: Scott CareyDate: 2010-01-18 23:37:12
Subject: Re: Inserting 8MB bytea: just 25% of disk perf used?

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