| 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: | 4B556C78.9000107@uci.cu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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,
>
> WBL
> --
> "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.
Regards
| From | Date | Subject | |
|---|---|---|---|
| Next Message | fkater@googlemail.com | 2010-01-19 10:16:07 | Re: Inserting 8MB bytea: just 25% of disk perf used? |
| Previous Message | Scott Carey | 2010-01-18 23:37:12 | Re: Inserting 8MB bytea: just 25% of disk perf used? |