Re: Sun performance - Major discovery!

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Sun performance - Major discovery!
Date: 2003-10-08 14:48:55
Message-ID: 20031008144855.GB11507@libertyrms.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

On Wed, Oct 08, 2003 at 08:36:56AM -0400, Jeff wrote:
>
> So here's the results using my load tester (single connection per beater,
> repeats the query 1000 times with different input each time (we'll get
> ~20k rows back), the query is a common query around here.

My worry about this test is that it gives us precious little
knowledge about concurrent connection slowness, which is where I find
the most significant problems. When we tried a Sunsoft cc vs gcc 2.95
on Sol 7 about 1 1/2 years ago, we found more or less no difference
once we added more than 5 connections (and we always have more than 5
connections). It might be worth trying again, though, since we moved
to Sol 8.

Thanks for the result.

--
----
Andrew Sullivan 204-4141 Yonge Street
Afilias Canada Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Matthew T. O'Connor 2003-10-08 14:52:25 Re: Disabling function validation
Previous Message Jeroen T. Vermeulen 2003-10-08 14:18:02 Re: Possible Commit Syntax Change for Improved TPS

Browse pgsql-performance by date

  From Date Subject
Next Message Neil Conway 2003-10-08 14:52:39 Re: Sun performance - Major discovery!
Previous Message Manfred Koizar 2003-10-08 14:35:24 Re: planner doesn't use multicolumn index