-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Wed, 9 Jan 2008 08:16:48 -0800 Alan Hodgson <ahodgson@xxxxxxxxx> wrote: > On Wednesday 09 January 2008, Adrian Moisey > <adrian@xxxxxxxxxxxxxxxxxxxx> wrote: > > > > Also, we're running the db on ext3 with noatime. Should I look at > > changing or getting rid of journaling ? > > No (unless you like really long fsck times). data=writeback is safe > with PostgreSQL, though. > Except :)... for pg_xlog. If you have pg_xlog on a different partition, feel free to run ext2 for it. Joshua D. Drake > > ---------------------------(end of > broadcast)--------------------------- TIP 7: You can help support the > PostgreSQL project by donating at > > http://www.postgresql.org/about/donate > - -- The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate SELECT 'Training', 'Consulting' FROM vendor WHERE name = 'CMD' -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHhPtyATb/zqfZUUQRAk32AKCTvJPBCvHtb4JWMu7+xwxQZdA/ZQCgn3K2 pCmcUXAiAibLkTgEwGVXPyQ= =H2bK -----END PGP SIGNATURE----- ---------------------------(end of broadcast)---------------------------TIP 6: explain analyze is your friend
