From: Josh Berkus <josh@agliodbs.com>
To: Roman Fail <rfail@posportal.com>
To: Josh Berkus <josh@agliodbs.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
To: sszabo@megazone23.bigpanda.com
Cc: pgsql-performance@postgresql.org
Subject: Re: 7.3.1 New install, large queries are slow
Date: Thu, 16 Jan 2003 09:28:28 -0800
Message-ID: <web-2316193@davinci.ethosmedia.com> (raw)
In-Reply-To: <9B1C77393DED0D4B9DAA1AA1742942DA0E4C02@pos_pdc.posportal.com>
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 hope we can come up with something soon.....it seems this index
> scan is a big part of the problem. I'm still really curious why the
> disk reads are so few with the index scan. Let's hope I can get it
> near the 3 second time for MSSQL by Friday!
Um, Roman, keep in mind this is a mailing list. I'm sure that
everyone here is happy to give you the tools to figure out how to fix
things, but only in a DIY fashion, and not on your schedule.
If you have a deadline, you'd better hire some paid query/database
tuning help. DB Tuning experts .... whether on MSSQL or Postgres ...
run about $250/hour last I checked.
-Josh Berkus
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: josh@agliodbs.com, rfail@posportal.com, tgl@sss.pgh.pa.us, sszabo@megazone23.bigpanda.com
Subject: Re: 7.3.1 New install, large queries are slow
In-Reply-To: <web-2316193@davinci.ethosmedia.com>
References: <9B1C77393DED0D4B9DAA1AA1742942DA0E4C02@pos_pdc.posportal.com> <web-2316193@davinci.ethosmedia.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