pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedBenchmarking postgres on Solaris/Linux
22+ messages / 12 participants
[nested] [flat]
* Benchmarking postgres on Solaris/Linux
@ 2004-03-23 00:05 Subbiah, Stalin <SSubbiah@netopia.com>
0 siblings, 3 replies; 22+ messages in thread
From: Subbiah, Stalin @ 2004-03-23 00:05 UTC (permalink / raw)
To: pgsql-performance; +Cc: 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>
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
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: [PERFORM] Benchmarking postgres on Solaris/Linux
@ 2004-03-23 05:20 Josh Berkus <josh@agliodbs.com>
parent: Subbiah, Stalin <SSubbiah@netopia.com>
2 siblings, 0 replies; 22+ messages in thread
From: Josh Berkus @ 2004-03-23 05:20 UTC (permalink / raw)
To: Subbiah, Stalin <SSubbiah@netopia.com>; pgsql-performance; +Cc: 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>
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
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: [PERFORM] Benchmarking postgres on Solaris/Linux
@ 2004-03-23 05:39 Mark Kirkwood <markir@paradise.net.nz>
parent: Subbiah, Stalin <SSubbiah@netopia.com>
2 siblings, 1 reply; 22+ messages in thread
From: Mark Kirkwood @ 2004-03-23 05:39 UTC (permalink / raw)
To: Subbiah, Stalin <SSubbiah@netopia.com>; +Cc: pgsql-performance; 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>
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.
>
>
>
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: [PERFORM] Benchmarking postgres on Solaris/Linux
@ 2004-03-23 16:15 Josh Berkus <josh@agliodbs.com>
parent: Mark Kirkwood <markir@paradise.net.nz>
0 siblings, 1 reply; 22+ messages in thread
From: Josh Berkus @ 2004-03-23 16:15 UTC (permalink / raw)
To: Mark Kirkwood <markir@paradise.net.nz>; Subbiah, Stalin <SSubbiah@netopia.com>; +Cc: pgsql-performance; 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>
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
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: [ADMIN] Benchmarking postgres on Solaris/Linux
@ 2004-03-23 17:36 Andrew Sullivan <ajs@crankycanuck.ca>
parent: Subbiah, Stalin <SSubbiah@netopia.com>
2 siblings, 0 replies; 22+ messages in thread
From: Andrew Sullivan @ 2004-03-23 17:36 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: [ADMIN] Benchmarking postgres on Solaris/Linux
@ 2004-03-23 18:40 Subbiah, Stalin <SSubbiah@netopia.com>
0 siblings, 2 replies; 22+ messages in thread
From: Subbiah, Stalin @ 2004-03-23 18:40 UTC (permalink / raw)
To: Andrew Sullivan <ajs@crankycanuck.ca>; pgsql-performance
We are looking into Sun V210 (2 x 1 GHz cpu, 2 gig ram, 5.8Os) vs. Dell 1750
(2 x 2.4 GHz xeon, 2 gig ram, RH3.0). database will mostly be
write intensive and disks will be on raid 10. Wondering if 64bit 1 GHz to
32bit 2.4 GHz make a big difference here.
Thanks!
-----Original Message-----
From: pgsql-performance-owner@postgresql.org
[mailto:pgsql-performance-owner@postgresql.org]On Behalf Of Andrew
Sullivan
Sent: Tuesday, March 23, 2004 9:37 AM
To: 'pgsql-performance@postgresql.org'
Subject: Re: [PERFORM] [ADMIN] Benchmarking postgres on Solaris/Linux
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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: [ADMIN] Benchmarking postgres on Solaris/Linux
@ 2004-03-23 18:51 Matt Clark <matt@ymogen.net>
parent: Subbiah, Stalin <SSubbiah@netopia.com>
1 sibling, 1 reply; 22+ messages in thread
From: Matt Clark @ 2004-03-23 18:51 UTC (permalink / raw)
To: Subbiah, Stalin <SSubbiah@netopia.com>; 'Andrew Sullivan' <ajs@crankycanuck.ca>; pgsql-performance
If it's going to be write intensive then the RAID controller will be the most important thing. A dual p3/500 with a write-back
cache will smoke either of the boxes you mention using software RAID on write performance.
As for the compute intensive side (complex joins & sorts etc), the Dell will most likely beat the Sun by some distance, although
what the Sun lacks in CPU power it may make up a bit in memory bandwidth/latency.
Matt
> -----Original Message-----
> From: pgsql-performance-owner@postgresql.org
> [mailto:pgsql-performance-owner@postgresql.org]On Behalf Of Subbiah,
> Stalin
> Sent: 23 March 2004 18:41
> To: 'Andrew Sullivan'; 'pgsql-performance@postgresql.org'
> Subject: Re: [PERFORM] [ADMIN] Benchmarking postgres on Solaris/Linux
>
>
> We are looking into Sun V210 (2 x 1 GHz cpu, 2 gig ram, 5.8Os) vs. Dell 1750
> (2 x 2.4 GHz xeon, 2 gig ram, RH3.0). database will mostly be
> write intensive and disks will be on raid 10. Wondering if 64bit 1 GHz to
> 32bit 2.4 GHz make a big difference here.
>
> Thanks!
>
> -----Original Message-----
> From: pgsql-performance-owner@postgresql.org
> [mailto:pgsql-performance-owner@postgresql.org]On Behalf Of Andrew
> Sullivan
> Sent: Tuesday, March 23, 2004 9:37 AM
> To: 'pgsql-performance@postgresql.org'
> Subject: Re: [PERFORM] [ADMIN] Benchmarking postgres on Solaris/Linux
>
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: [ADMIN] Benchmarking postgres on Solaris/Linux
@ 2004-03-23 18:53 Anjan Dave <adave@vantage.com>
0 siblings, 0 replies; 22+ messages in thread
From: Anjan Dave @ 2004-03-23 18:53 UTC (permalink / raw)
To: Subbiah, Stalin <SSubbiah@netopia.com>; Andrew Sullivan <ajs@crankycanuck.ca>; pgsql-performance
What bus speeds?
533MHz on the 32-bit Intel will give you about 4.2Gbps of IO throughput...
I think the Sun will be 150MHz, 64bit is 2.4Gbps of IO. Correct me if i am wrong.
Thanks,
Anjan
-----Original Message-----
From: Subbiah, Stalin [mailto:SSubbiah@netopia.com]
Sent: Tue 3/23/2004 1:40 PM
To: 'Andrew Sullivan'; 'pgsql-performance@postgresql.org'
Cc:
Subject: Re: [PERFORM] [ADMIN] Benchmarking postgres on Solaris/Linux
We are looking into Sun V210 (2 x 1 GHz cpu, 2 gig ram, 5.8Os) vs. Dell 1750
(2 x 2.4 GHz xeon, 2 gig ram, RH3.0). database will mostly be
write intensive and disks will be on raid 10. Wondering if 64bit 1 GHz to
32bit 2.4 GHz make a big difference here.
Thanks!
-----Original Message-----
From: pgsql-performance-owner@postgresql.org
[mailto:pgsql-performance-owner@postgresql.org]On Behalf Of Andrew
Sullivan
Sent: Tuesday, March 23, 2004 9:37 AM
To: 'pgsql-performance@postgresql.org'
Subject: Re: [PERFORM] [ADMIN] Benchmarking postgres on Solaris/Linux
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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: [ADMIN] Benchmarking postgres on Solaris/Linux
@ 2004-03-23 20:13 Josh Berkus <josh@agliodbs.com>
parent: Matt Clark <matt@ymogen.net>
0 siblings, 2 replies; 22+ messages in thread
From: Josh Berkus @ 2004-03-23 20:13 UTC (permalink / raw)
To: Matt Clark <matt@ymogen.net>; Subbiah, Stalin <SSubbiah@netopia.com>; 'Andrew Sullivan' <ajs@crankycanuck.ca>; pgsql-performance
Matt, Stalin,
> As for the compute intensive side (complex joins & sorts etc), the Dell will
most likely beat the Sun by some distance, although
> what the Sun lacks in CPU power it may make up a bit in memory bandwidth/
latency.
Personally, I've been unimpressed by Dell/Xeon; I think the Sun might do
better than you think, comparitively. On all the Dell servers I've used so
far, I've not seen performance that comes even close to the hardware specs.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: [ADMIN] Benchmarking postgres on Solaris/Linux
@ 2004-03-23 20:42 Subbiah, Stalin <SSubbiah@netopia.com>
0 siblings, 3 replies; 22+ messages in thread
From: Subbiah, Stalin @ 2004-03-23 20:42 UTC (permalink / raw)
To: 'josh@agliodbs.com' <josh@agliodbs.com>; Matt Clark <matt@ymogen.net>; Subbiah, Stalin <SSubbiah@netopia.com>; Andrew Sullivan <ajs@crankycanuck.ca>; pgsql-performance
As anyone done performance benchmark testing with solaris sparc/intel linux.
I once read a post here, which had benchmarking test results for using
different filesystem like xfs, ext3, ext2, ufs etc. i couldn't find that
link anymore and google is failing on me, so anyone have the link handy.
Thanks!
-----Original Message-----
From: Josh Berkus [mailto:josh@agliodbs.com]
Sent: Tuesday, March 23, 2004 12:13 PM
To: Matt Clark; Subbiah, Stalin; 'Andrew Sullivan';
pgsql-performance@postgresql.org
Subject: Re: [PERFORM] [ADMIN] Benchmarking postgres on Solaris/Linux
Matt, Stalin,
> As for the compute intensive side (complex joins & sorts etc), the Dell
will
most likely beat the Sun by some distance, although
> what the Sun lacks in CPU power it may make up a bit in memory bandwidth/
latency.
Personally, I've been unimpressed by Dell/Xeon; I think the Sun might do
better than you think, comparitively. On all the Dell servers I've used
so
far, I've not seen performance that comes even close to the hardware specs.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: [ADMIN] Benchmarking postgres on Solaris/Linux
@ 2004-03-23 20:52 scott.marlowe <scott.marlowe@ihs.com>
parent: Josh Berkus <josh@agliodbs.com>
1 sibling, 0 replies; 22+ messages in thread
From: scott.marlowe @ 2004-03-23 20:52 UTC (permalink / raw)
To: Josh Berkus <josh@agliodbs.com>; +Cc: Matt Clark <matt@ymogen.net>; Subbiah, Stalin <SSubbiah@netopia.com>; 'Andrew Sullivan' <ajs@crankycanuck.ca>; pgsql-performance
On Tue, 23 Mar 2004, Josh Berkus wrote:
> Matt, Stalin,
>
> > As for the compute intensive side (complex joins & sorts etc), the Dell will
> most likely beat the Sun by some distance, although
> > what the Sun lacks in CPU power it may make up a bit in memory bandwidth/
> latency.
>
> Personally, I've been unimpressed by Dell/Xeon; I think the Sun might do
> better than you think, comparitively. On all the Dell servers I've used so
> far, I've not seen performance that comes even close to the hardware specs.
We use a 2600 at work (dual 2.8GHz) with the LSI/Megaraid based battery
backed caching controller, and it flies. Truly flies.
It's not Dell that's so slow, it's the default adaptec RAID controller or
IDE drives that are slow. Ours has 533 MHz memory bus, by the way.
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: [ADMIN] Benchmarking postgres on Solaris/Linux
@ 2004-03-23 20:53 matt@ymogen.net
parent: Josh Berkus <josh@agliodbs.com>
1 sibling, 1 reply; 22+ messages in thread
From: matt@ymogen.net @ 2004-03-23 20:53 UTC (permalink / raw)
To: josh@agliodbs.com; +Cc: Subbiah, Stalin <ssubbiah@netopia.com>; 'Andrew Sullivan' <ajs@crankycanuck.ca>; pgsql-performance
> Personally, I've been unimpressed by Dell/Xeon; I think the Sun might do
> better than you think, comparitively. On all the Dell servers I've used
> so
> far, I've not seen performance that comes even close to the hardware
> specs.
It's true that any difference will be far less than the GHz ratio, and I
can't really speak for Dell servers in general, but a pair of 2.4GHz Xeons
in a Dell workstation gets about 23 SPECint_rate2000, and a pair of 1GHz
UltraSparc IIIs in a SunFire V210 gets 10. The ratios are the same for
other non-FP benchmarks.
Now the Suns do have some architectural advantages, and they used to have
far superior memory bandwidth than intel boxes, and they often still do
for more than 2 cpus, and definitely do for more than four. But my
personal experience is that for 4 cpus or less the entry level UNIX
offerings from Sun/IBM/HP fell behind in raw performance (FP excepted) two
or three years ago. The posh hardware's an entirely different matter of
course.
On the other hand, I can think of innumerable non performance related
reasons to buy a 'real UNIX box' as a low end DB server. CPU performance
is way down the priority list compared with IO throughput, stability,
manageability, support, etc etc.
Given that the original question was about a very heavily write-oriented
environment, I'd take the Sun every day of the week, assuming that those
compile option changes have sorted out the oddly slow PG performance at
last.
M
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: [ADMIN] Benchmarking postgres on Solaris/Linux
@ 2004-03-23 21:56 Craig Thomas <craiger@osdl.org>
parent: Subbiah, Stalin <SSubbiah@netopia.com>
2 siblings, 0 replies; 22+ messages in thread
From: Craig Thomas @ 2004-03-23 21:56 UTC (permalink / raw)
To: Subbiah, Stalin <SSubbiah@netopia.com>; +Cc: 'josh@agliodbs.com' <josh@agliodbs.com>; Matt Clark <matt@ymogen.net>; 'Andrew Sullivan' <ajs@crankycanuck.ca>; pgsql-performance
On Tue, 2004-03-23 at 12:42, Subbiah, Stalin wrote:
> As anyone done performance benchmark testing with solaris sparc/intel linux.
> I once read a post here, which had benchmarking test results for using
> different filesystem like xfs, ext3, ext2, ufs etc. i couldn't find that
> link anymore and google is failing on me, so anyone have the link handy.
>
> Thanks!
This link: http://developer.osdl.org/markw/ takes you to Mark Wong's
database developer page. The top set of links shows performance results
for Linux kernels running an OLTP workload (dbt-2) under PostgreSQL. He
has numbers for ia32 and ia64 under different file system types.
To do a "good enough" comparison, one would need to port this test kit
to solaris. So far, this kit is only running on Linux. No one, to my
knowledge has it running on any other platform. But I suspect there are
some working to port the kits.
>
> -----Original Message-----
> From: Josh Berkus [mailto:josh@agliodbs.com]
> Sent: Tuesday, March 23, 2004 12:13 PM
> To: Matt Clark; Subbiah, Stalin; 'Andrew Sullivan';
> pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] [ADMIN] Benchmarking postgres on Solaris/Linux
>
>
> Matt, Stalin,
>
> > As for the compute intensive side (complex joins & sorts etc), the Dell
> will
> most likely beat the Sun by some distance, although
> > what the Sun lacks in CPU power it may make up a bit in memory bandwidth/
> latency.
>
> Personally, I've been unimpressed by Dell/Xeon; I think the Sun might do
> better than you think, comparitively. On all the Dell servers I've used
> so
> far, I've not seen performance that comes even close to the hardware specs.
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: [ADMIN] Benchmarking postgres on Solaris/Linux
@ 2004-03-23 22:03 Andrew Sullivan <ajs@crankycanuck.ca>
parent: matt@ymogen.net
0 siblings, 1 reply; 22+ messages in thread
From: Andrew Sullivan @ 2004-03-23 22:03 UTC (permalink / raw)
To: pgsql-performance
On Tue, Mar 23, 2004 at 08:53:42PM -0000, matt@ymogen.net wrote:
> is way down the priority list compared with IO throughput, stability,
> manageability, support, etc etc.
Indeed, if our Suns actually diabled the broken hardware when they
died, fell over, and rebooted themselves, I'd certainly praise them
to heaven. But I have to say that the really very good reporting of
failing memory has saved me some headaches.
> environment, I'd take the Sun every day of the week, assuming that those
> compile option changes have sorted out the oddly slow PG performance at
> last.
I seem to have hit a bad batch of Dell hardware recently, which makes
me second this opinion.
I should say, also, that my initial experience of AIX has been
extremely good. I can't comment on the fun it might involve in the
long haul, of course.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end up well.
--Dennis Ritchie
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: [ADMIN] Benchmarking postgres on Solaris/Linux
@ 2004-03-23 22:10 Bill Moran <wmoran@potentialtech.com>
parent: Subbiah, Stalin <SSubbiah@netopia.com>
2 siblings, 0 replies; 22+ messages in thread
From: Bill Moran @ 2004-03-23 22:10 UTC (permalink / raw)
To: Subbiah, Stalin <SSubbiah@netopia.com>; +Cc: pgsql-performance
Subbiah, Stalin wrote:
> As anyone done performance benchmark testing with solaris sparc/intel linux.
> I once read a post here, which had benchmarking test results for using
> different filesystem like xfs, ext3, ext2, ufs etc. i couldn't find that
> link anymore and google is failing on me, so anyone have the link handy.
If you're talking about the work I did, it's here:
http://www.potentialtech.com/wmoran/ (then follow the link)
Anyway, that should be easily portable to any platform that will run Postgres,
but I don't know how useful it is in comparing two different platforms. See
the information in the document. It was intended only to test disk access speed,
and attempts to flood the HDD system with database work to do.
>
> Thanks!
>
> -----Original Message-----
> From: Josh Berkus [mailto:josh@agliodbs.com]
> Sent: Tuesday, March 23, 2004 12:13 PM
> To: Matt Clark; Subbiah, Stalin; 'Andrew Sullivan';
> pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] [ADMIN] Benchmarking postgres on Solaris/Linux
>
>
> Matt, Stalin,
>
>
>>As for the compute intensive side (complex joins & sorts etc), the Dell
>
> will
> most likely beat the Sun by some distance, although
>
>>what the Sun lacks in CPU power it may make up a bit in memory bandwidth/
>
> latency.
>
> Personally, I've been unimpressed by Dell/Xeon; I think the Sun might do
> better than you think, comparitively. On all the Dell servers I've used
> so
> far, I've not seen performance that comes even close to the hardware specs.
>
--
Bill Moran
Potential Technologies
http://www.potentialtech.com
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: [ADMIN] Benchmarking postgres on Solaris/Linux
@ 2004-03-23 22:48 Aaron Werman <awerman2@hotmail.com>
parent: Subbiah, Stalin <SSubbiah@netopia.com>
2 siblings, 0 replies; 22+ messages in thread
From: Aaron Werman @ 2004-03-23 22:48 UTC (permalink / raw)
To: Subbiah, Stalin <SSubbiah@netopia.com>; josh@agliodbs.com; Matt Clark <matt@ymogen.net>; 'Andrew Sullivan' <ajs@crankycanuck.ca>; pgsql-performance
Are you talking about
http://www.potentialtech.com/wmoran/postgresql.php#conclusion
----- Original Message -----
From: "Subbiah, Stalin" <SSubbiah@netopia.com>
To: <josh@agliodbs.com>; "Matt Clark" <matt@ymogen.net>; "Subbiah, Stalin"
<SSubbiah@netopia.com>; "'Andrew Sullivan'" <ajs@crankycanuck.ca>;
<pgsql-performance@postgresql.org>
Sent: Tuesday, March 23, 2004 3:42 PM
Subject: Re: [PERFORM] [ADMIN] Benchmarking postgres on Solaris/Linux
> As anyone done performance benchmark testing with solaris sparc/intel
linux.
> I once read a post here, which had benchmarking test results for using
> different filesystem like xfs, ext3, ext2, ufs etc. i couldn't find that
> link anymore and google is failing on me, so anyone have the link handy.
>
> Thanks!
>
> -----Original Message-----
> From: Josh Berkus [mailto:josh@agliodbs.com]
> Sent: Tuesday, March 23, 2004 12:13 PM
> To: Matt Clark; Subbiah, Stalin; 'Andrew Sullivan';
> pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] [ADMIN] Benchmarking postgres on Solaris/Linux
>
>
> Matt, Stalin,
>
> > As for the compute intensive side (complex joins & sorts etc), the Dell
> will
> most likely beat the Sun by some distance, although
> > what the Sun lacks in CPU power it may make up a bit in memory
bandwidth/
> latency.
>
> Personally, I've been unimpressed by Dell/Xeon; I think the Sun might do
> better than you think, comparitively. On all the Dell servers I've used
> so
> far, I've not seen performance that comes even close to the hardware
specs.
>
> --
> -Josh Berkus
> Aglio Database Solutions
> San Francisco
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: [ADMIN] Benchmarking postgres on Solaris/Linux
@ 2004-03-23 23:18 Subbiah, Stalin <SSubbiah@netopia.com>
0 siblings, 0 replies; 22+ messages in thread
From: Subbiah, Stalin @ 2004-03-23 23:18 UTC (permalink / raw)
To: Bill Moran <wmoran@potentialtech.com>; Subbiah, Stalin <SSubbiah@netopia.com>; +Cc: pgsql-performance
Yep. Thanks Bill.
-----Original Message-----
From: Bill Moran [mailto:wmoran@potentialtech.com]
Sent: Tuesday, March 23, 2004 2:10 PM
To: Subbiah, Stalin
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] [ADMIN] Benchmarking postgres on Solaris/Linux
Subbiah, Stalin wrote:
> As anyone done performance benchmark testing with solaris sparc/intel
linux.
> I once read a post here, which had benchmarking test results for using
> different filesystem like xfs, ext3, ext2, ufs etc. i couldn't find that
> link anymore and google is failing on me, so anyone have the link handy.
If you're talking about the work I did, it's here:
http://www.potentialtech.com/wmoran/ (then follow the link)
Anyway, that should be easily portable to any platform that will run
Postgres,
but I don't know how useful it is in comparing two different platforms. See
the information in the document. It was intended only to test disk access
speed,
and attempts to flood the HDD system with database work to do.
>
> Thanks!
>
> -----Original Message-----
> From: Josh Berkus [mailto:josh@agliodbs.com]
> Sent: Tuesday, March 23, 2004 12:13 PM
> To: Matt Clark; Subbiah, Stalin; 'Andrew Sullivan';
> pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] [ADMIN] Benchmarking postgres on Solaris/Linux
>
>
> Matt, Stalin,
>
>
>>As for the compute intensive side (complex joins & sorts etc), the Dell
>
> will
> most likely beat the Sun by some distance, although
>
>>what the Sun lacks in CPU power it may make up a bit in memory bandwidth/
>
> latency.
>
> Personally, I've been unimpressed by Dell/Xeon; I think the Sun might do
> better than you think, comparitively. On all the Dell servers I've used
> so
> far, I've not seen performance that comes even close to the hardware
specs.
>
--
Bill Moran
Potential Technologies
http://www.potentialtech.com
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: [ADMIN] Benchmarking postgres on Solaris/Linux
@ 2004-03-23 23:35 matt@ymogen.net
parent: Andrew Sullivan <ajs@crankycanuck.ca>
0 siblings, 1 reply; 22+ messages in thread
From: matt@ymogen.net @ 2004-03-23 23:35 UTC (permalink / raw)
To: Andrew Sullivan <ajs@crankycanuck.ca>; +Cc: pgsql-performance
> Indeed, if our Suns actually diabled the broken hardware when they
> died, fell over, and rebooted themselves, I'd certainly praise them
> to heaven. But I have to say that the really very good reporting of
> failing memory has saved me some headaches.
Ha! Yes, it would seem the obvious thing to do - but as you say, at least
you get told what borked and may even be able to remove it without
stopping the machine. Sometimes. Or at least you get a nice lunch from
your Sun reseller.
> I should say, also, that my initial experience of AIX has been
> extremely good. I can't comment on the fun it might involve in the
> long haul, of course.
The current crop of power4+ boxen is reputed to even be able to recover
from a failed CPU without a restart. Not *always* one imagines, but
usefully often enough for the banking mob to get sweaty over the feature.
More importantly though, IBM seems committed to supporting all this
goodness under Linux too (though not BSD I fear - sorry Bruce)
Now if these vendors could somehow eliminate downtime due to human error
we'd be talking *serious* reliablity.
M
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: [PERFORM] Benchmarking postgres on Solaris/Linux
@ 2004-03-24 08:53 Mark Kirkwood <markir@paradise.net.nz>
parent: Josh Berkus <josh@agliodbs.com>
0 siblings, 0 replies; 22+ messages in thread
From: Mark Kirkwood @ 2004-03-24 08:53 UTC (permalink / raw)
To: Josh Berkus <josh@agliodbs.com>; +Cc: Subbiah, Stalin <SSubbiah@netopia.com>; pgsql-performance; 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>
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
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: [ADMIN] Benchmarking postgres on Solaris/Linux
@ 2004-03-24 12:04 Andrew Sullivan <ajs@crankycanuck.ca>
parent: matt@ymogen.net
0 siblings, 1 reply; 22+ messages in thread
From: Andrew Sullivan @ 2004-03-24 12:04 UTC (permalink / raw)
To: pgsql-performance
On Tue, Mar 23, 2004 at 11:35:47PM -0000, matt@ymogen.net wrote:
> More importantly though, IBM seems committed to supporting all this
> goodness under Linux too (though not BSD I fear - sorry Bruce)
Although so far they don't. And let me tell you, AIX's reputation
for being strange is well earned. It has some real nice features,
though: topas is awfully nice for spotting bottlenecks, and it works
in a terminal so you don't have to have X and all the rest of that
stuff installed. We're just in the preliminary stages with this
system, but my experience so far has been positive. On new machines,
though, one _hopes_ that hardware failures are relatively infrequent.
> Now if these vendors could somehow eliminate downtime due to human error
> we'd be talking *serious* reliablity.
You mean making the OS smart enough to know when clearing the arp
cache is a bonehead operation, or just making the hardware smart
enough to realise that the keyswitch really shouldn't be turned
while 40 people are logged in? (Either way, I agree this'd be an
improvement. It'd sure make colocation a lot less painful.)
A
--
Andrew Sullivan | ajs@crankycanuck.ca
In the future this spectacle of the middle classes shocking the avant-
garde will probably become the textbook definition of Postmodernism.
--Brad Holland
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: [ADMIN] Benchmarking postgres on Solaris/Linux
@ 2004-03-24 12:39 Matt Clark <matt@ymogen.net>
parent: Andrew Sullivan <ajs@crankycanuck.ca>
0 siblings, 0 replies; 22+ messages in thread
From: Matt Clark @ 2004-03-24 12:39 UTC (permalink / raw)
To: Andrew Sullivan <ajs@crankycanuck.ca>; pgsql-performance
> > Now if these vendors could somehow eliminate downtime due to human error
> > we'd be talking *serious* reliablity.
>
> You mean making the OS smart enough to know when clearing the arp
> cache is a bonehead operation, or just making the hardware smart
> enough to realise that the keyswitch really shouldn't be turned
> while 40 people are logged in? (Either way, I agree this'd be an
> improvement. It'd sure make colocation a lot less painful.)
Well I was joking really, but those are two very good examples! Yes, machines should require extra confirmation for operations like
those. Hell, even a simple 'init 0' would be well served by a prompt that says "There are currently 400 network sockets open, 50
remote users logged in, and 25 disk IOs per second. What's more, there's nobody logged in at the console to boot me up again
afterwards - are you _sure_ you want to shut the machine down?". It's also crazy that there's no prompt after an 'rm -rf' (we could
have 'rm -rf --iacceptfullresponsibility' for an unprompted version).
Stuff like that would have saved me from a few embarrassments in the past for sure ;-)
It drives me absolutely nuts every time I see a $staggeringly_expensive clustered server whose sysadmins are scared to do a failover
test in case something goes wrong! Or which has worse uptime than my desktop PC because the cluster software's poorly set up or
administered. Or which has both machines on the same circuit breaker. I could go on but it's depressing me.
Favourite anecdote: A project manager friend of mine had a new 'lights out' datacenter to set up. The engineers, admins and
operators swore blind that everything had been tested in every possible way, and that incredible uptime was guaranteed. 'So if I
just pull this disk out everything will keep working?' he asked, and then pulled the disk out without waiting for an answer...
Ever since he told me that story I've done exactly that with every piece of so-called 'redundant' hardware a vendor tries to flog
me. Ask them to set it up, then just do nasty things to it without asking for permission. Less than half the gear makes it through
that filter, and actually you can almost tell from the look on the technical sales rep's face as you reach for the
drive/cable/card/whatever whether it will or won't.
M
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: [ADMIN] Benchmarking postgres on Solaris/Linux
@ 2004-03-24 17:05 Vivek Khera <khera@kcilink.com>
parent: Subbiah, Stalin <SSubbiah@netopia.com>
1 sibling, 0 replies; 22+ messages in thread
From: Vivek Khera @ 2004-03-24 17:05 UTC (permalink / raw)
To: pgsql-performance
>>>>> "SS" == Stalin Subbiah <Subbiah> writes:
SS> We are looking into Sun V210 (2 x 1 GHz cpu, 2 gig ram, 5.8Os)
SS> vs. Dell 1750 (2 x 2.4 GHz xeon, 2 gig ram, RH3.0). database will
SS> mostly be write intensive and disks will be on raid 10. Wondering
SS> if 64bit 1 GHz to 32bit 2.4 GHz make a big difference here.
Spend all your money speeding up your disk system. If you're mostly
writing (like my main app) then that's your bottleneck. I use a dell
2650 with external RAID 5 on 14 spindles. I didn't need that much
disk space, but went for maxing out the number of spindles. RAID 5
was faster than RAID10 or RAID50 with this configuration for me.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera@kciLink.com Rockville, MD +1-301-869-4449 x806
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/
^ permalink raw reply [nested|flat] 22+ messages in thread
end of thread, other threads:[~2004-03-24 17:05 UTC | newest]
Thread overview: 22+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-03-23 00:05 Benchmarking postgres on Solaris/Linux Subbiah, Stalin <SSubbiah@netopia.com>
2004-03-23 05:20 ` Josh Berkus <josh@agliodbs.com>
2004-03-23 05:39 ` Mark Kirkwood <markir@paradise.net.nz>
2004-03-23 16:15 ` Josh Berkus <josh@agliodbs.com>
2004-03-24 08:53 ` Mark Kirkwood <markir@paradise.net.nz>
2004-03-23 17:36 ` Andrew Sullivan <ajs@crankycanuck.ca>
2004-03-23 18:40 Re: [ADMIN] Benchmarking postgres on Solaris/Linux Subbiah, Stalin <SSubbiah@netopia.com>
2004-03-23 18:51 ` Matt Clark <matt@ymogen.net>
2004-03-23 20:13 ` Josh Berkus <josh@agliodbs.com>
2004-03-23 20:52 ` scott.marlowe <scott.marlowe@ihs.com>
2004-03-23 20:53 ` matt@ymogen.net
2004-03-23 22:03 ` Andrew Sullivan <ajs@crankycanuck.ca>
2004-03-23 23:35 ` matt@ymogen.net
2004-03-24 12:04 ` Andrew Sullivan <ajs@crankycanuck.ca>
2004-03-24 12:39 ` Matt Clark <matt@ymogen.net>
2004-03-24 17:05 ` Vivek Khera <khera@kcilink.com>
2004-03-23 18:53 Re: [ADMIN] Benchmarking postgres on Solaris/Linux Anjan Dave <adave@vantage.com>
2004-03-23 20:42 Re: [ADMIN] Benchmarking postgres on Solaris/Linux Subbiah, Stalin <SSubbiah@netopia.com>
2004-03-23 21:56 ` Craig Thomas <craiger@osdl.org>
2004-03-23 22:10 ` Bill Moran <wmoran@potentialtech.com>
2004-03-23 22:48 ` Aaron Werman <awerman2@hotmail.com>
2004-03-23 23:18 Re: [ADMIN] Benchmarking postgres on Solaris/Linux Subbiah, Stalin <SSubbiah@netopia.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox