From: Mark Mielke <mark@mark.mielke.cc>
To: mbguy2000-1@yahoo.com
Cc: pgsql-performance@postgresql.org
Subject: Re: Transaction Log
Date: Wed, 29 Aug 2007 15:54:05 -0400
Message-ID: <46D5CEDD.5010303@mark.mielke.cc> (raw)
In-Reply-To: <782718.73151.qm@web31603.mail.mud.yahoo.com>
References: <782718.73151.qm@web31603.mail.mud.yahoo.com>
mbguy2000-1@yahoo.com wrote:
> For best performance, the transaction log should be on a separate disk.
>
> Does the writing of the log benefit from a battery backed controller
> as well? If not, what do people think about writing the transaction
> log to a flash card or the like?
How popular are the battery backed RAM drives that exist today? I don't
recall seeing them spoken about in this mailing list. The local geek
shop has these devices on sale. Are they still too expensive?
For those that don't know what I am talking about - they are PCI devices
that present themselves as a hard drive, but are filled with commodity
RAM instead of a magnetic platter, and a battery that lasts a few weeks
without external power.
Cheers,
mark
--
Mark Mielke <mark@mielke.cc>
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mark@mark.mielke.cc, mbguy2000-1@yahoo.com
Subject: Re: Transaction Log
In-Reply-To: <46D5CEDD.5010303@mark.mielke.cc>
* 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