From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <vvk@vvk.pp.ru>
X-Spam-Checker-Version: SpamAssassin 3.2.5 (2008-06-10) on sa.int.altlinux.org
X-Spam-Level: 
X-Spam-Status: No, score=-2.7 required=5.0 tests=AWL,BAYES_00,
	DNS_FROM_OPENWHOIS,RCVD_IN_DNSWL_MED autolearn=ham version=3.2.5
To: ALT Linux sysadmins' discussion <sysadmins@lists.altlinux.org>
Organization: Tyumen State University
References: <30328219.19.1309949853101.JavaMail.javamailuser@localhost>
	<4E167914.8000806@bgc.perm.ru>
	<20110708083356.GA12391@t60p.mithraen.ru>
From: "Vladimir V. Kamarzin" <vvk@vvk.pp.ru>
Date: Mon, 01 Aug 2011 18:01:08 +0600
In-Reply-To: <20110708083356.GA12391@t60p.mithraen.ru>
	(mithraen@freesource.info's message of "Fri,
	8 Jul 2011 12:33:56 +0400")
Message-ID: <m3y5zdz6gr.fsf@vvk.distance.ru>
User-Agent: Gnus/5.1008 (Gnus v5.10.8) XEmacs/21.5-b29 (linux)
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-5
Content-Transfer-Encoding: quoted-printable
Subject: Re: [Sysadmins] btrfs
X-BeenThere: sysadmins@lists.altlinux.org
X-Mailman-Version: 2.1.12
Precedence: list
Reply-To: ALT Linux sysadmins' discussion <sysadmins@lists.altlinux.org>
List-Id: ALT Linux sysadmins' discussion <sysadmins.lists.altlinux.org>
List-Unsubscribe: <https://lists.altlinux.org/mailman/options/sysadmins>,
	<mailto:sysadmins-request@lists.altlinux.org?subject=unsubscribe>
List-Archive: <http://lists.altlinux.org/pipermail/sysadmins>
List-Post: <mailto:sysadmins@lists.altlinux.org>
List-Help: <mailto:sysadmins-request@lists.altlinux.org?subject=help>
List-Subscribe: <https://lists.altlinux.org/mailman/listinfo/sysadmins>,
	<mailto:sysadmins-request@lists.altlinux.org?subject=subscribe>
X-List-Received-Date: Mon, 01 Aug 2011 12:01:14 -0000
Archived-At: <http://lore.altlinux.org/sysadmins/m3y5zdz6gr.fsf@vvk.distance.ru/>
List-Archive: <http://lore.altlinux.org/sysadmins/>

>>>>> On 08 Jul 2011 at 14:33 "m" =3D=3D mithraen  writes:

m> On Fri, Jul 08, 2011 at 09:27:16AM +0600, =B4=DC=D8=E2=E0=D8=D9 =B4=D5=
=D3=E2=EF=E0=D5=D2 wrote:
>> =BF=E0=DE=D1=DE=D2=D0=DB =E1=E2=D0=D2=D8=E2=EC =DF=DE=D4 postgres..=20
m> ext4 + data=3Djournal (=DD=D0 =DE=E2=D4=D5=DB=EC=DD=DE=DC =D4=D8=E1=DA=
=D5 =D8=DB=D8 =DB=E3=E7=E8=D5 SSD) the best.

=B4=DB=EF postgres =DD=D5 =DD=D0=D4=DE journal.

Tip: Because WAL restores database file contents after a crash, journaled f=
ile
systems are not necessary for reliable storage of the data files or WAL
files. In fact, journaling overhead can reduce performance, especially if
journaling causes file system data to be flushed to disk. Fortunately, data
flushing during journaling can often be disabled with a file system mount
option, e.g. data=3Dwriteback on a Linux ext3 file system. Journaled file
systems do improve boot speed after a crash.

http://www.postgresql.org/docs/9.0/interactive/wal-intro.html

=BB=E3=E7=E8=D5 =D2=EB=DA=DB=EE=E7=D8=E2=EC write cache, =D5=E1=DB=D8 =DD=
=D5=E2=E3 =D2=E1=EF=DA=D8=E5 BBU.
http://www.postgresql.org/docs/9.0/interactive/wal-reliability.html

--=20
vvk