On Tue, 2005-01-18 at 07:43 +0700, David Garamond wrote: > Tzahi Fadida wrote: > > I recommend you don't use ext3 for any database: > > http://seclists.org/lists/linux-kernel/2005/Jan/0641.html > > > > apparently its still buggy. > > So what is the recommended fs under Linux? I don't need the best > speed/throughput, but I prefer not to use ext2 due to long fsck time. I Wouldn't ext2 also allow the possibility of a missing file? Even though postgres does WAL, couldn't ext2 forget a file or not record that a new file has been created? In other words, does PostgreSQL assume that the filesystem at least journals the metadata? Regards, Jeff Davis ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly