pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: DI Hasenöhrl <i.hasenoehrl@aon.at>
Cc: pgsql-sql@postgresql.org
Subject: Re: make query faster??
Date: Wed, 5 Dec 2001 10:28:54 -0800 (PST)
Message-ID: <20011205101538.S16316-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <003601c17d6a$398f9100$01011eac@irina>


On Wed, 5 Dec 2001, [iso-8859-1] DI Hasenöhrl wrote:

> Thank you for your response, but I'm not quite clear.
>
> Is *sort_mem* the same as postgres' starting option -S *Sortsize*,
> which is by default 512Kb
> At this time I increased sortsize to 1024Kb, but the costs from
> explain are the same as before and I can't see, that the query is
> faster

IIRC the explain costs may not change.  If your table really only
has 4000 rows, I don't see why it would need to drop off to disk,
but while the query is running, you can see if pg_sorttemp* files
are being created under your data directory (which would show
that it is going out to disk and that you may need to raise -S
again).  Otherwise, is the data involved something you can share?
It might help for us to be able to try it elsewhere to see how
it performs.

> Please, can you explain, what *cost=341.63..341.63* means

It's an estimate of cost.  I believe the first is startup cost
and the last total cost.  You probably want to read the performance
tips section of the user's guide.





view thread (4+ messages)

Message-ID: <20011205101538.S16316-100000@megazone23.bigpanda.com>
Permalink:  ../20011205101538.S16316-100000@megazone23.bigpanda.com/
Also on:    postgresql.org/message-id/20011205101538.S16316-100000@megazone23.bigpanda.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 using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: sszabo@megazone23.bigpanda.com, i.hasenoehrl@aon.at
  Subject: Re: make query faster??
  In-Reply-To: <20011205101538.S16316-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