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