Re: Raw vs Filesystem

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Am Dienstag, 30. März 2004 06:00 schrieb Christopher Browne:
> el_vigia_ec(at)hotmail(dot)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(at)inwise(dot)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-----