-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Am Dienstag, 30. März 2004 06:00 schrieb Christopher Browne: > [EMAIL PROTECTED] ("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: [EMAIL PROTECTED] 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----- ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html