pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (66+ messages)  latest in thread

Message-ID: <web-2316193@davinci.ethosmedia.com>
Permalink:  ../web-2316193@davinci.ethosmedia.com/
Also on:    postgresql.org/message-id/web-2316193@davinci.ethosmedia.com

 · 

reply

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