Re: order of performance

I thought the other relevenat thread of discussion was stability- isn't
Linux easier to support because that's what the PG community is most
familiar with? Especially compared with Solaris and Windows...

> -----Original Message-----
> From: sfpug-owner(at)postgresql(dot)org
> [mailto:sfpug-owner(at)postgresql(dot)org] On Behalf Of Josh Berkus
> Sent: Wednesday, October 05, 2005 7:59 PM
> To: Jeff Frost
> Cc: sfpug(at)postgresql(dot)org
> Subject: Re: [sfpug] order of performance
>
> Jeff,
>
> > > 10. Linux 2.6.10+
> >
> > Do you think the 2.6.10 kernel added something special or
> is it 2.6.x
> > in general?
>
> The "not crashing" feature.
>
> > I was a solaris admin for years and years..I like Sun too!
> How close
> > is the Solaris x86 performance with Solaris 10?
>
> Not. It's like using HP-UX or Linux 2.0. The biggest issue
> is the lack of
> advanced filesystem support (Solaris still uses the stone-age
> version of UFS) forcing applications to all handle their own
> readahead, cache management, etc (which as you know Postgres
> doesn't). Also, there's an issue with sorts we're still
> working out which may be a bug in the PostgreSQL code.
>
> That being said, we are actively working with several
> technicians at Sun, and PostgreSQL 8.2 (with Solaris 10.1)
> might restore Solaris to a competitive
> position. Also, keep in mind that I do data warehousing; I
> understand the
> the OLTP performance numbers are closer to the Linux equivalents.
>
> --
> Josh Berkus
> Aglio Database Solutions
> San Francisco
>
>