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