From: Neil Conway <neilc@samurai.com>
To: Jeff <threshar@torgo.978.org>
Cc: Darcy Buskermolen <darcy@wavefire.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Sun vs a P2. Interesting results.
Date: Tue, 26 Aug 2003 15:37:29 -0400
Message-ID: <20030826193729.GG64198@home.samurai.com> (raw)
In-Reply-To: <Pine.BSF.4.44.0308261502330.20304-100000@torgo.978.org>
References: <200308261201.55733.darcy@wavefire.com>
<Pine.BSF.4.44.0308261502330.20304-100000@torgo.978.org>
On Tue, Aug 26, 2003 at 03:05:12PM -0400, Jeff wrote:
> On Tue, 26 Aug 2003, Darcy Buskermolen wrote:
> > I'm still seeing differences in the planner estimates, have you run a VACUUM
> > ANALYZE prior to running these tests?
> >
> I did. I shall retry that.. but the numbers (the cost estimates) are
> pretty close on both. the actual times are very different.
I don't see why you need to bother, the query plans & cost estimates
are similar enough I doubt that's the problem.
> As I said in my first email IO isn't the problem here - the data set is
> small enough that it is all cached (~10MB). iostat reports 0 activity on
> the disks on both the sun and p2.
Would it be possible to get a profile (e.g. gprof output) for a postgres
backend executing the query on the Sun machine?
-Neil
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: neilc@samurai.com, threshar@torgo.978.org, darcy@wavefire.com
Subject: Re: Sun vs a P2. Interesting results.
In-Reply-To: <20030826193729.GG64198@home.samurai.com>
References: <200308261201.55733.darcy@wavefire.com> <Pine.BSF.4.44.0308261502330.20304-100000@torgo.978.org> <20030826193729.GG64198@home.samurai.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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