Re: PostgreSQL over NFS?

* Mike Castle <dalgoda(at)ix(dot)netcom(dot)com> [010209 16:57] wrote:
> On Fri, Feb 09, 2001 at 04:23:10PM -0800, Alfred Perlstein wrote:
> > Anyhow, if the idea is just to get a nice backup system, you could
> > do a pg_dump and write the output to a NFS mounted FS, there's probably
> > less that can go wrong with a large sequencial write than heavy shared
> > read/write/seek.
>
> Still new to this but....
>
> Can pg_dump be piped through gzip et al? Use a few cpu strokes to save
> network bandwidth may be beneficial.

Yes it can. It's a cpu/space/network tradeoff, if you use low
compression you might do pretty well, saving CPU and at the same
time getting pretty good compression on plain-text.

--
-Alfred Perlstein - [bright(at)wintelcom(dot)net|alfred(at)freebsd(dot)org]
"I have the heart of a child; I keep it in a jar on my desk."