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

Re: Disk Failure Scenarios

From: "Michael Artz" <mlartz(at)gmail(dot)com>
To: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Disk Failure Scenarios
Date: 2006-04-27 09:46:36
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
> > -Disk 2: If the transaction log dies, all changes since the last
> > checkpoint are lost, right?  Again, if I set up an empty pg_xlog
> > directory somewhere else, the DB should run just fine, right?
> No, because there's no way to know what state the data pages are in.
> Data may have made it to disk, may not have, partial page write, etc...

As far as I understand it, data is only written to the WAL except when the
WAL is checkpointing, right?  So if your WAL disk crashes and you aren't int
the middle of a checkpoint, there is a chance that you would just lose data
since the last checkpoint.  Am I missing something?

Now the real question is: why are you trying to run without raid?

I have a single, very fast disk lying around, and I was just wondering what
parts of the DB I could "safely" put on it.  I was thinking either the WAL
or and index.  I have essentially 15 10K drives and 1 15K drive, and don't
quite know what to do with it.


In response to

pgsql-general by date

Next:From: Rodrigo SakaiDate: 2006-04-27 10:45:39
Previous:From: Chris VelevitchDate: 2006-04-27 09:34:54
Subject: Re: Mailing list setup issue

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