Re: Tuning for PostGreSQL Database

From: Sean Chittenden (sean_at_chittenden.org)
Date: 07/20/03

  • Next message: Jim C. Nasby: "Re: Tuning for PostGreSQL Database" 
    Date: Sun, 20 Jul 2003 04:25:50 -0700
To: Dan Langille <dan@langille.org>

    > > > FreeBSD 4.8 or 5.1?
    > >
    > > Probably 5.1-RELEASE.
    >
    > I would recommend 4.8 over 5.1. Especially if you intend this to be
    > a production server. 5.1 is not ready for public consumption.

    Public consumption, yes. Production consumption, no.

    5.1 is still pretty crippled in its current state because it's not
    Giant free yet. Once Giant free, however, 5.X will be much closer to
    production ready and should be quicker as a result of the fine grained
    locking (or so everyone hopes). The simple locking mechanism in 4.x
    does have some advantages in cases and should be a consistent
    performer on UP machines and under most loads.... whether or not 5.x
    over takes 4.X in terms of speed, is the subject of great debate, but
    many are optimistic that it will be at some point, just not at the
    moment. 5.X, will however (and without much doubt), scale much better
    than 4.X on multiple processor machines, though I'm not sure where
    that stands at the moment in terms of being completed and should
    likely be directed to current@ or questions@ instead of here. -sc 

    -- 
Sean Chittenden
_______________________________________________
freebsd-performance@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-performance
To unsubscribe, send any mail to "freebsd-performance-unsubscribe@freebsd.org"
  • Next message: Jim C. Nasby: "Re: Tuning for PostGreSQL Database"