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.
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