pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: JEDIDIAH <jedi@nomad.mishnet>
To: pgsql-admin@postgresql.org
Subject: Re: Multiple WALs for PITR ?
Date: Thu, 07 Oct 2004 10:29:31 -0500
Message-ID: <slrncmaon0.uhn.jedi@nomad.mishnet> (raw)
References: <28292295$109709783341646269224fa2.08260020@config19.schlund.de>

On 2004-10-06, simon@2ndquadrant.com <simon@2ndquadrant.com> wrote:
>
> Michael Kleiser <mkl@webde-ag.de> wrote on 06.10.2004, 16:29:08:
>> I wan`t to use Point in Time Recovery
>> I allread read http://developer.postgresql.org/docs/postgres/backup-online.html#BACKUP-ARCHIVING-WAL
>> 
>
> Good!
>
>> But I still wonder, if it is possible for PostgreSQL 8.0 to write multiple, redundant WAL-Files
>> like Oracles with its redo-log-groups ?
>
> Not currently.
>
> That was something I considered, though in the end lacked both
> implementation time and justification for.

	WAL archival is more decoupled from WAL generation.

	You can use this to exploit more IO parallelism so that the same
disk isn't being written to and read from at the same time.

	Now, the concept of WAL groups would provide an extra level of
redundancy for your crash recovery files. On some of the cheaper sort of
systems that I've seen postgres deployed on this could be very useful.

[deletia]

-- 
        Negligence will never equal intent, no matter how you 
attempt to distort reality to do so. This is what separates         ||| 
the real butchers from average Joes (or Fritzes) caught up in      / | \
events not in their control.


                                                     



view thread (9+ messages)  latest in thread

Message-ID: <slrncmaon0.uhn.jedi@nomad.mishnet>
Permalink:  ../slrncmaon0.uhn.jedi@nomad.mishnet/
Also on:    postgresql.org/message-id/slrncmaon0.uhn.jedi@nomad.mishnet

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: jedi@nomad.mishnet
  Subject: Re: Multiple WALs for PITR ?
  In-Reply-To: <slrncmaon0.uhn.jedi@nomad.mishnet>
  References: <28292295$109709783341646269224fa2.08260020@config19.schlund.de> <slrncmaon0.uhn.jedi@nomad.mishnet>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox