From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-sql@postgresql.org
Subject: Re:
Date: Tue, 29 Aug 2006 13:40:58 -0400
Message-ID: <20060829174058.GB6539@phlogiston.dyndns.org> (raw)
In-Reply-To: <7539aebb0608290944r40556b5fl2b047e845e68bd6c@mail.gmail.com>
References: <7539aebb0608290944r40556b5fl2b047e845e68bd6c@mail.gmail.com>
On Tue, Aug 29, 2006 at 12:44:28PM -0400, Sumeet wrote:
> me at all. Also i tried the explain analyze and what i found was the query
> execution plan keeps on changes. Is there any better way to gain control
My bet is that you don't have enough sample data to support a
consistent query plan. SET STATISTICS might be what you need.
> parameters but dint really help. Also can somebody point me out to links
> which explains more about query execution plans..i.e. each of parameters
> like bitmap heap scan, index scan....etc...
On [mumble techdocs I think] there's a tutorial called EXPLAIN
explained. Google will help you -- just use that title, with maybe
"postgresql" tacked onto your search string.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
The plural of anecdote is not data.
--Roger Brinner
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: ajs@crankycanuck.ca
Subject: Re:
In-Reply-To: <20060829174058.GB6539@phlogiston.dyndns.org>
* 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