Re: Postgresql on file system EXT2 or EXT3

One important point here is reboot time after a crash or non-clean
shutdown.

A very large ext2 file system can take a LONG time to do an integrity
check on reboot (30 minutes?), and may lose data.

The same partition with ext3 enabled will run it's journalled recovery in
a couple of seconds, marking crash recovery MUCH faster and safer.

I don't think this should be ignored in a discussion of these filesystems.
Reboot time can be a real killer with ext2, even without the potential for
data loss.

Craig

On Thu, 27 Nov 2003, Rich Shepard wrote:

> On Thu, 27 Nov 2003, Carmen Wai wrote:
>
> > I would like to know whether there is any different in installing Postgresql
> > on the Linux system with file system of EXT2 or EXT3. I have two machines
> > with idential OS (Red Hat 7.3 install with postgresql 7.3.4) but with
> > different file system, 1 is EXT2 and the other is EXT3. When I insert 10,000
> > records to the two machines, I found that the machine with EXT2 insert much
> > quicker than the other with EXT3.
> >
> > Is postgresqk perform better with EXT2 file system?
>
> Carmen,
>
>   Consider the overhead in having the security of a journaling file system
> when you make your comparisons.
>
> Rich
>
>