Re: PostgreSQL over NFS?
От | Alfred Perlstein |
---|---|
Тема | Re: PostgreSQL over NFS? |
Дата | |
Msg-id | 20010209165851.B3274@fw.wintelcom.net обсуждение исходный текст |
Ответ на | Re: PostgreSQL over NFS? (Mike Castle <dalgoda@ix.netcom.com>) |
Ответы |
Re: PostgreSQL over NFS?
|
Список | pgsql-general |
* Mike Castle <dalgoda@ix.netcom.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@wintelcom.net|alfred@freebsd.org] "I have the heart of a child; I keep it in a jar on my desk."
В списке pgsql-general по дате отправления: