Skip site navigation (1) Skip section navigation (2)

Re: WAL logs multiplexing?

From: Dmitry Panov <dmitry(at)tsu(dot)tula(dot)ru>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: WAL logs multiplexing?
Date: 2005-12-28 16:10:01
Message-ID: 1135786201.6858.33.camel@ip6-localhost (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
On Wed, 2005-12-28 at 11:05 -0500, Tom Lane wrote:
> Dmitry Panov <dmitry(at)tsu(dot)tula(dot)ru> writes:
> > Yes, but if the server has crashed earlier the script won't be called
> > and if the filesystem can't be recovered the changes will be lost. My
> > point is the server should write into both (or more) files at the same
> > time.
> 
> As for that, I agree with the other person: a RAID array does that just
> fine, and with much higher performance than we could muster.
> 

Please see my reply to the other person. The other place can be on an
NFS mounted directory. This is what the Oracle guys do and they know
what they are doing (despite the latest release is total crap).

Best regards,
-- 
Dmitry O Panov          | mailto:dmitry(at)tsu(dot)tula(dot)ru
Tula State University   | Fidonet: Dmitry Panov, 2:5022/5.13
Dept. of CS & NIT       | http://www.tsu.tula.ru/



In response to

Responses

pgsql-hackers by date

Next:From: Ian HardingDate: 2005-12-28 16:38:05
Subject: Re: WAL logs multiplexing?
Previous:From: Tom LaneDate: 2005-12-28 16:05:16
Subject: Re: WAL logs multiplexing?

pgsql-general by date

Next:From: Ian HardingDate: 2005-12-28 16:38:05
Subject: Re: WAL logs multiplexing?
Previous:From: Tom LaneDate: 2005-12-28 16:05:16
Subject: Re: WAL logs multiplexing?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group