From: Torsten Neuer <tneuer@inwise.de>
To: pgsql-admin@postgresql.org
Subject: Re: Raw vs Filesystem
Date: Tue, 6 Apr 2004 10:34:54 +0200
Message-ID: <200404061034.56355.tneuer@inwise.de> (raw)
In-Reply-To: <m3vfkn2dcv.fsf@wolfe.cbbrowne.com>
References: <BAY8-F31m24TzmKYTge000166a5@hotmail.com>
<m3vfkn2dcv.fsf@wolfe.cbbrowne.com>
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Am Dienstag, 30. März 2004 06:00 schrieb Christopher Browne:
> el_vigia_ec@hotmail.com ("Jaime Casanova") asked:
> > so, the real question is what is the best filesystem for optimal speed
> > in postgresql?
>
> The smart-alec answer would be... "Veritas, of course!"
>
> But seriously, it depends on many factors you have not provided
> information about.
>
> -> Different operating systems support different filesystems; you
> should probably specify what OS you are using.
>
> -> Hardware choices have ENORMOUSLY more impact on speed than any
> choice of filesystems.
One method for further optimizing access on database files can be to mount the
partition where the database files are kept in a fashion that omits most of
the bookkeeping of the filesystem, e.g. using the -noatime option. Any
filesystem that is heavily accessed will greatly benefit from this -
especially if the filesystem resides on a RAID 5 disk array since updating
the access times will cause any checksums to be re-computed and written back
to the array.
hth,
Torsten
- --
InWise - Wirtschaftlich-Wissenschaftlicher Internet Service GmbH
Waldhofstraße 14 Tel: +49-4101-403605
D-25474 Ellerbek Fax: +49-4101-403606
E-Mail: info@inwise.de Internet: http://www.inwise.de
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
iD8DBQFAcmuunSCI/lmEFI8RAtE+AKDeKS63Yt7fkhiZ3OAH8tj2uXQ7HgCguQ4s
34VyZ5+9Vuum9nmDaDblsSs=
=6B+8
-----END PGP SIGNATURE-----
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: tneuer@inwise.de
Subject: Re: Raw vs Filesystem
In-Reply-To: <200404061034.56355.tneuer@inwise.de>
References: <BAY8-F31m24TzmKYTge000166a5@hotmail.com> <m3vfkn2dcv.fsf@wolfe.cbbrowne.com> <200404061034.56355.tneuer@inwise.de>
* 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