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
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
