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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: Transaction Log


  • From: Mark Mielke <mark(at)mark(dot)mielke(dot)cc>
  • To: mbguy2000-1(at)yahoo(dot)com
  • Cc: pgsql-performance(at)postgresql(dot)org
  • Subject: Re: Transaction Log
  • Date: Wed, 29 Aug 2007 15:54:05 -0400
  • Message-id: <46D5CEDD.5010303@mark.mielke.cc> <text/plain>

mbguy2000-1(at)yahoo(dot)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(at)mielke(dot)cc>



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group