Re: pg_dump / pg_dumpall / memory issues

Shridhar has a good point using nice.  I know RedHat supports nice 
because I have installed a totally background program that uses "nice 
19" as part of its command line.

I just successfully tried this on a RedHat 7.3:

nice -n 15 pg_dumpall >testdump.sql

It seems to work.  However, my SQL server is so lightly loaded I cannot 
verify that it actually *helps*.

-Kyle

Shridhar Daithankar wrote:
> If you have an OS that binds nice value of a process to it's I/O priority, you 
> can lower the priority  of pg_dump so that it runs very slow, so to speak.
> 
> I believe freeBSD does this. Not sure if linux does it as well.
> 
> HTH
> 
>  Shridhar
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/docs/faqs/FAQ.html