What would the the best choice for the WAL mirroring, raid3 or 5. How big does the WAL grow? mirroring is fine as long as the size isn't too big. -- Ian Willis -----Original Message----- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Friday, 20 April 2001 9:22 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] Best practice [EMAIL PROTECTED] writes: > We use Ingres where I work and when setting up a server we always > try to ensure that the log and data files are on different spindles. This would be good practice in PG simply for performance reasons. Ideally the WAL log should be on a disk that has nothing else to do, so that you never have to seek somewhere else than the current WAL segment. I'm not sure that we can yet guarantee very much about recovery from disk hardware failures. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
