Обсуждение: Benchmarking postgres on Solaris/Linux

Поиск
Список
Период
Сортировка

Benchmarking postgres on Solaris/Linux

От
"Subbiah, Stalin"
Дата:
As anyone done benchmarking tests with postgres running on solaris and linux
(redhat) assuming both environment has similar hardware, memory, processing
speed etc. By reading few posts here, i can see linux would outperform
solaris cause linux being very good at kernel caching than solaris which is
being the key performance booster for postgres.  what is the preferred OS
for postgres deployment if given an option between linux and solaris. As
well as filesystem to be used (xfs, ufs, ext3...). Any pointer to source of
information is appreciated.

Thanks,
Stalin

Re: Benchmarking postgres on Solaris/Linux

От
Josh Berkus
Дата:
Stalin,

> As anyone done benchmarking tests with postgres running on solaris and linux
> (redhat) assuming both environment has similar hardware, memory, processing
> speed etc. By reading few posts here, i can see linux would outperform
> solaris cause linux being very good at kernel caching than solaris which is
> being the key performance booster for postgres.  what is the preferred OS
> for postgres deployment if given an option between linux and solaris. As
> well as filesystem to be used (xfs, ufs, ext3...). Any pointer to source of
> information is appreciated.

Most of that is a matter of opinion.   Read the cumulative archives of this
list.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


Re: Benchmarking postgres on Solaris/Linux

От
Mark Kirkwood
Дата:
The hardware platform to deploy onto may well influence your choice :

Intel is usually the most cost effective , which means using Linux makes
sense in that case (anybody measured Pg performance on Solaris/Intel....?).

If however, you are going to run a very "big in some sense" database,
then 64 bit hardware is desirable and you can look at the Sun offerings.
In this case you can run either Linux or Solaris (some informal
benchmarks suggest that for small numbers of cpus, Linux is probably
faster).

It might be worth considering Apple if you want a 64-bit chip that has a
clock speed comparable to Intel's - the Xserv is similarly priced to Sun
V210 (both dual cpu 1U's).

Are you free to choose any hardware?

best wishes

Mark

Subbiah, Stalin wrote:

>(snipped) what is the preferred OS
>for postgres deployment if given an option between linux and solaris.
>
>
>


Re: Benchmarking postgres on Solaris/Linux

От
Josh Berkus
Дата:
Mark,

> It might be worth considering Apple if you want a 64-bit chip that has a
> clock speed comparable to Intel's - the Xserv is similarly priced to Sun
> V210 (both dual cpu 1U's).

Personally I'd stay *far* away from the XServs until Apple learns to build
some real server harware.    The current XServs have internal parts more
appropriate to a Dell desktop (promise controller, low-speed commodity IDE
drives), than a server.

If Apple has prices these IU desktop machines similar to Sun, then I sense
doom ahead for the Apple Server Division.

--
Josh Berkus
Aglio Database Solutions
San Francisco

Re: [ADMIN] Benchmarking postgres on Solaris/Linux

От
Andrew Sullivan
Дата:
On Mon, Mar 22, 2004 at 04:05:45PM -0800, Subbiah, Stalin wrote:
> being the key performance booster for postgres.  what is the preferred OS
> for postgres deployment if given an option between linux and solaris. As

One thing this very much depends on is what you're trying to do.
Suns have a reputation for greater reliability.  While my own
experience with Sun hardware has been rather shy of sterling, I _can_
say that it stands head and shoulders above a lot of the x86 gear you
can get.

If you're planning to use Solaris on x86, don't bother.  Solaris is a
slow, bloated pig compared to Linux, at least when it comes to
managing the largish number of processes that Postgres requires.

If pure speed is what you're after, I have found that 2-way, 32 bit
Linux on P-IIIs compares very favourably to 4 way 64 bit Ultra SPARC
IIs.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
The fact that technology doesn't work is no bar to success in the marketplace.
        --Philip Greenspun

Re: Benchmarking postgres on Solaris/Linux

От
Mark Kirkwood
Дата:

Josh Berkus wrote:

>Mark,
>
>
>
>>It might be worth considering Apple if you want a 64-bit chip that has a
>>clock speed comparable to Intel's - the Xserv is similarly priced to Sun
>>V210 (both dual cpu 1U's).
>>
>>
>
>Personally I'd stay *far* away from the XServs until Apple learns to build
>some real server harware.    The current XServs have internal parts more
>appropriate to a Dell desktop (promise controller, low-speed commodity IDE
>drives), than a server.
>
>If Apple has prices these IU desktop machines similar to Sun, then I sense
>doom ahead for the Apple Server Division.
>
>
>
(thinks...) Point taken - the Xserv is pretty "entry level"...

However, having recently benchmarked  a 280R vs a PIII Dell using a
Promise ide raid controller - and finding the Dell comparable (with
write cache *disabled*), I suspect that the Xserv has a pretty good
chance of outperforming a V210  (certainly would be interesting to try
out....)

What I think has happened is that over the last few years then "cheap /
slow" ide stuff has gotten pretty fast - even when you make "write mean
write"....

cheers

Mark