From: "Vladimir V. Kamarzin" <vvk@vvk.pp.ru>
To: ALT Linux sysadmins' discussion <sysadmins@lists.altlinux.org>
Subject: Re: [Sysadmins] btrfs
Date: Mon, 01 Aug 2011 18:01:08 +0600
Message-ID: <m3y5zdz6gr.fsf@vvk.distance.ru> (raw)
In-Reply-To: <20110708083356.GA12391@t60p.mithraen.ru> (mithraen@freesource.info's message of "Fri, 8 Jul 2011 12:33:56 +0400")
>>>>> On 08 Jul 2011 at 14:33 "m" == mithraen writes:
m> On Fri, Jul 08, 2011 at 09:27:16AM +0600, Дмитрий Дегтярев wrote:
>> Пробовал ставить под postgres..
m> ext4 + data=journal (на отдельном диске или лучше SSD) the best.
Для postgres не надо journal.
Tip: Because WAL restores database file contents after a crash, journaled file
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=writeback 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
Лучше выключить write cache, если нету всяких BBU.
http://www.postgresql.org/docs/9.0/interactive/wal-reliability.html
--
vvk
next prev parent reply other threads:[~2011-08-01 12:01 UTC|newest]
Thread overview: 20+ messages / expand[flat|nested] mbox.gz Atom feed top
2011-07-06 10:57 Alexei Takaseev
2011-07-07 13:32 ` Anton Farygin
2011-07-08 3:27 ` Дмитрий Дегтярев
2011-07-08 8:33 ` Денис Смирнов
2011-07-08 11:42 ` Maks Re
2011-07-20 20:34 ` Денис Смирнов
2011-07-20 22:27 ` [Sysadmins] ipsec Patlasov YuriI
2011-07-21 5:55 ` Dmitriy Kruglikov
2011-07-21 7:59 ` Patlasov YuriI
2011-07-21 10:22 ` Ilia Menchikh
2011-07-21 10:52 ` Patlasov YuriI
2011-07-21 11:28 ` Ilia Menchikh
2011-07-22 7:54 ` Mikhail
2011-07-22 14:45 ` Patlasov YuriI
2011-07-22 15:00 ` Michael Shigorin
2011-07-25 6:21 ` Denis Kuznetsov
2011-07-30 14:38 ` Patlasov YuriI
2011-08-05 17:59 ` Michael Shigorin
2011-08-01 12:01 ` Vladimir V. Kamarzin [this message]
2011-08-02 23:41 ` [Sysadmins] btrfs Денис Смирнов
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=m3y5zdz6gr.fsf@vvk.distance.ru \
--to=vvk@vvk.pp.ru \
--cc=sysadmins@lists.altlinux.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
ALT Linux sysadmins discussion
This inbox may be cloned and mirrored by anyone:
git clone --mirror http://lore.altlinux.org/sysadmins/0 sysadmins/git/0.git
# If you have public-inbox 1.1+ installed, you may
# initialize and index your mirror using the following commands:
public-inbox-init -V2 sysadmins sysadmins/ http://lore.altlinux.org/sysadmins \
sysadmins@lists.altlinux.org sysadmins@lists.altlinux.ru sysadmins@lists.altlinux.com
public-inbox-index sysadmins
Example config snippet for mirrors.
Newsgroup available over NNTP:
nntp://lore.altlinux.org/org.altlinux.lists.sysadmins
AGPL code for this site: git clone https://public-inbox.org/public-inbox.git