From: Sumeet <asumeet@gmail.com>
To: pgsql-sql@postgresql.org
Date: Tue, 29 Aug 2006 12:44:28 -0400
Message-ID: <7539aebb0608290944r40556b5fl2b047e845e68bd6c@mail.gmail.com> (raw)
Hi All,
I'm having very strange problems with indexing, I have a large number of
partial indexes, when i try to run some queries sometimes the queries run
very fast and sometimes they are 100times slower than what i ran
before.....I tried running vacuum analyze couple of times and it dint help
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
over these, I tried turning seqscan off, and messing with some other
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...
--
Thanks,
Sumeet
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: asumeet@gmail.com
Subject: Re:
In-Reply-To: <7539aebb0608290944r40556b5fl2b047e845e68bd6c@mail.gmail.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