Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 1A2F69FB6FC for ; Wed, 29 Aug 2007 16:29:07 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 74142-03 for ; Wed, 29 Aug 2007 16:28:46 -0300 (ADT) X-Greylist: delayed 00:06:38.299611 by SQLgrey-1.7.5 Received: from web31601.mail.mud.yahoo.com (web31601.mail.mud.yahoo.com [68.142.198.147]) by postgresql.org (Postfix) with SMTP id A3D729FB6BA for ; Wed, 29 Aug 2007 16:28:48 -0300 (ADT) Received: (qmail 65210 invoked by uid 60001); 29 Aug 2007 19:22:03 -0000 X-YMail-OSG: NCwAZWsVM1lgRiUtX0eLZyGM.Hgagf02xrgp7wO8kNpv9pHmFBsv5jQ0tQjr.P.4LpNdTecUQw-- Received: from [68.142.201.149] by web31601.mail.mud.yahoo.com via HTTP; Wed, 29 Aug 2007 12:22:03 PDT X-Mailer: YahooMailRC/651.50 YahooMailWebService/0.7.134 Date: Wed, 29 Aug 2007 12:22:03 -0700 (PDT) From: Markus Benne Subject: Transaction Log To: pgsql-performance@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-17621483-1188415323=:64168" Message-ID: <464321.64168.qm@web31601.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=BAYES_50=0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200708/384 X-Sequence-Number: 26514 --0-17621483-1188415323=:64168 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable For best performance, the transaction log should be on a separate disk.=0A= =0ADoes 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?=0A=0A --0-17621483-1188415323=:64168 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: quoted-printable
For best performance, the transaction log should be on a separate d= isk.

Does the writing of the log benefit from a battery backed contr= oller as well?  If not, what do people think about writing the transac= tion log to a flash card or the like?
--0-17621483-1188415323=:64168--