Re: Postgresql on file system EXT2 or EXT3

Been there, done that.

I'll buy more memory to help overcome the (I find subtle) disk performance
issue long before I will give up a journalling file system: Telling the
users they have to wait 20 min for the system to come back is a bitter pill
to swallow. With a journalling file system most linux systems are back up
within 120 seconds, and many types of users may not even notice it was down.
:)

Terry Fielder
Manager Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
terry(at)greatgulfhomes(dot)com
Fax: (416) 441-9085

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Craig
> O'Shannessy
> Sent: Thursday, November 27, 2003 8:04 PM
> To: Rich Shepard
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] 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
> >
> >
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so
> that your
> message can get through to the mailing list cleanly
>