As another post pointed out, you need to set cflags to get optimization
under Solaris on that flavor of Postgresql.
Also, Postgresql tends to get its best performance from the free unixes,
Linux and BSD. those are available for Sun Sparcs, but postgresql in 64
bit mode on those boxes is still a bit cutting edge.
It might be worth a try to set up the sun to dual boot to either BSD or
Linux and test Postgresql under that environment to see how it works and
compare it to Sun after you've set the cflags and recompiled.
On Tue, 11 Nov 2003, Chris Field wrote:
> we are looking at Xeon, We are currently running it on a quad sun v880
> compiled to be 64bit and have been getting dreadful performance. I don't
> think we really have much to gain from going 64bit.
>
>
> ----- Original Message -----
> From: "Ron Johnson" <ron.l.johnson@cox.net>
> To: "PgSQL Performance ML" <pgsql-performance@postgresql.org>
> Sent: Tuesday, November 11, 2003 8:24 PM
> Subject: Re: [PERFORM] Value of Quad vs. Dual Processor machine
>
>
> > On Tue, 2003-11-11 at 17:32, Chris Field wrote:
> > > We are getting ready to spec out a new machine and are wondering about
> > > the wisdom of buying a quad versus a dual processor machine. Seing as
> > > how postgres in not a threaded application, and this server will only be
> > > used for log/transaction analysis (it will only ever have a few large
> > > queries running). Is there any performance to be gained, and if so is
> > > it worth the large cost? Any thoughts/experience are much
> > > appreciated...
> >
> > Xeon or Opteron? The faster Opterons *really* blaze, especially
> > in 64-bit mode. As others have said, though, RAM and I/O are most
> > important.
> >
> > --
> > -----------------------------------------------------------------
> > Ron Johnson, Jr. ron.l.johnson@cox.net
> > Jefferson, LA USA
> >
> > "As I like to joke, I may have invented it, but Microsoft made it
> > popular"
> > David Bradley, regarding Ctrl-Alt-Del
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/docs/faqs/FAQ.html
> >
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
>