pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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-----



view thread (4+ messages)

Message-ID: <200404061034.56355.tneuer@inwise.de>
Permalink:  ../200404061034.56355.tneuer@inwise.de/
Also on:    postgresql.org/message-id/200404061034.56355.tneuer@inwise.de

 · 

reply

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