Re: Raw vs Filesystem - Mailing list pgsql-admin

From Torsten Neuer
Subject Re: Raw vs Filesystem
Date
Msg-id 200404061034.56355.tneuer@inwise.de
Whole thread Raw
In response to Re: Raw vs Filesystem  (Christopher Browne <cbbrowne@acm.org>)
List pgsql-admin
-----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-----

pgsql-admin by date:

Previous
From: "Eric Yum"
Date:
Subject: PostgreSQL backup issue
Next
From: JC Jan Christensen
Date:
Subject: Running Postgresql 7.4.2 on Windows 2000 with Cygwin !