Shaw Terwilliger <[EMAIL PROTECTED]> writes:
> Besides dumping and COPY'ing the data into the second server, is there
> another form of easy one-way replication available? My schema has just
Have you looked at PG's replication? It's included in 7.1, and you
can get it from (I think) www.postgr
> The part about cache incoherency is very true, the _only_ cache coherency
> NFS offers is _only_ in the v3 spec, and is specifically called 'wcc'
> 'weak cache coherency' (afaik). So yes, you can expect differnent
> NFS clients to get different inconsistant views on heavily modified
> files unl
Shaw Terwilliger wrote:
> Besides dumping and COPY'ing the data into the second server, is there
> another form of easy one-way replication available? My schema has just
> a few simple tables (six tables, a few rows each). But these tables
> may hold a few million records each. I've estimated t
* Shaw Terwilliger <[EMAIL PROTECTED]> [010209 16:18] wrote:
> Alfred Perlstein wrote:
> > Actually NFS has very strong write ordering semantics, it just has
> > terrible cache coherency. Meaning two machines accessing the same
> > file will most likely see different things if the file is updated
Steve Wolfe wrote:
> They may want to put the data on a file server, so that it gets backed up,
> and has the advantage of a hardware fault-tolerant RAID array. Tht has it's
> merits, but I don't think it woul dbe that great for performance. We spent
> the money to put another RAID array in th
Alfred Perlstein wrote:
> Actually NFS has very strong write ordering semantics, it just has
> terrible cache coherency. Meaning two machines accessing the same
> file will most likely see different things if the file is updated
> moderately.
I'm not an NFS guru by any means, but I've noticed ep
Alfred Perlstein wrote:
> NFS == Not F** Stable, don't do it. :) Any DBA will want to
> hurt you when he hears about you running a production DB over NFS.
Well, I thought it wasn't a very safe thing to do. Their network
administrator (the guy who buys machines, schedules backups, etc.)
sug
Bruce Momjian wrote:
> It is not performance I would be concerned about, but reliability. NFS
> has no state for reliability. I have to ask why they are using NFS
> rather than putting it on a drive local to the machine. If they say
> they want to share the data between two machines, that is ev
* Tom Lane <[EMAIL PROTECTED]> [010209 15:40] wrote:
> Shaw Terwilliger <[EMAIL PROTECTED]> writes:
> > I have a client who wants to know how PostgreSQL (7) will perform over
> > NFS. The NFS client is Solaris, the server is a big network storage=20
> > appliance. The network is probably gigabit
> It is not performance I would be concerned about, but reliability. NFS
> has no state for reliability. I have to ask why they are using NFS
> rather than putting it on a drive local to the machine. If they say
> they want to share the data between two machines, that is even crazier.
They m
Shaw Terwilliger <[EMAIL PROTECTED]> writes:
> I have a client who wants to know how PostgreSQL (7) will perform over
> NFS. The NFS client is Solaris, the server is a big network storage=20
> appliance. The network is probably gigabit ethernet.
> My first reaction is to tell them they're just
* Shaw Terwilliger <[EMAIL PROTECTED]> [010209 15:12] wrote:
> I've been using PostgreSQL for a few years now in various projects, and
> I've been very happy with its features and performance.
>
> I have a client who wants to know how PostgreSQL (7) will perform over
> NFS. The NFS client is Sol
-- Start of PGP signed section.
> I've been using PostgreSQL for a few years now in various projects, and
> I've been very happy with its features and performance.
>
> I have a client who wants to know how PostgreSQL (7) will perform over
> NFS. The NFS client is Solaris, the server is a big net
I've been using PostgreSQL for a few years now in various projects, and
I've been very happy with its features and performance.
I have a client who wants to know how PostgreSQL (7) will perform over
NFS. The NFS client is Solaris, the server is a big network storage
appliance. The network is p
14 matches
Mail list logo
