From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Josh Berkus <josh@agliodbs.com>
Cc: Roman Fail <rfail@posportal.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: 7.3.1 New install, large queries are slow
Date: Thu, 16 Jan 2003 09:47:02 -0800 (PST)
Message-ID: <20030116094210.L6318-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <web-2316193@davinci.ethosmedia.com>
On Thu, 16 Jan 2003, Josh Berkus wrote:
> Roman,
>
> > > Hey, Roman, how many records in BatchDetail, anyway?
> >
> > 23 million.
>
> And MSSQL is returning results in 3 seconds? I find that a bit hard
> to believe, unless this query is called repeatedly and that's the
> figure for the last call, where the records are being cached. I'll
> have to look at your hardware descriptions again.
>
> > It seems to me that the big, big isolated problem is the index scan
> > on batchdetail.tranamount.
>
> Nope. This was a misimpression caused by batchdetail waiting for a
> bunch of other processes to complete. Sometimes the parallelizing
> gives me a wrong impression of what's holding up the query. Sorry if I
> confused you.
I'm still not sure that it isn't a big part given that the time went down
by a factor of about 4 when index scans were disabled and a sequence scan
was done and that a sequence scan over the table with no other tables
joined looked to take about 5 minutes itself and the difference between
that seqscan and the big query was only about 20 seconds when
enable_indexscan was off unless I'm misreading those results.
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: sszabo@megazone23.bigpanda.com, josh@agliodbs.com, rfail@posportal.com, tgl@sss.pgh.pa.us
Subject: Re: 7.3.1 New install, large queries are slow
In-Reply-To: <20030116094210.L6318-100000@megazone23.bigpanda.com>
References: <web-2316193@davinci.ethosmedia.com> <20030116094210.L6318-100000@megazone23.bigpanda.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