pg_xlog safety

From: Vivek Khera <khera(at)kcilink(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_xlog safety
Date: 2003-01-21 20:43:40
Message-ID: x7iswi44jn.fsf@onceler.kciLink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I reconfigured my database server this weekend based on some notes
posted here. What I did was change the 5-disk RAID5 into a 4-disk
RAID10 plus one spare drive.

Now, this should have made things much faster, but from the looks of
it, I'm not so sure it got faster. Reindexing the dump after loading
the data took *way* longer than I expected. However, now that it is
reindexed and vacuum analyzed, things do appear faster. I'm not sure
if that's just from having the indexes rebuilt or what...

So this leads me to my question: one of the tips for performance is to
move the pg_xlog to its own disk. Now that I have a spare disk I was
considering moving pg_xlog there. However, that's the only disk that
wouldn't be RAID protected. What would happen to the db if that disk
failed? If I were able to perform a clean shutdown, replace that
disk, and start up postgres again, would it be ok with the pg_xlog
directory empty? Is it only used for startup after an unclean
shutdown or for every startup?

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera(at)kciLink(dot)com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message codeWarrior 2003-01-21 21:08:22 Re: grant to all tables
Previous Message Peter Gibbs 2003-01-21 20:30:24 Re: repost of how to do select in a constraint