From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Viktor Bojovi* <viktor.bojovic@gmail.com>
To: pgsql-admin@postgresql.org
To: pgsql-sql@postgresql.org
Subject: Re: function based index problem
Date: Wed, 31 Aug 2011 16:53:52 -0500
Message-ID: <4E5E672002000025000409E7@gw.wicourts.gov> (raw)
In-Reply-To: <CAJu1cLZvOYadLj3g60Q6Tnqtjk1CZPjdr=T4E89MzUeWaR8TRg@mail.gmail.com>
References: <CAJu1cLZvOYadLj3g60Q6Tnqtjk1CZPjdr=T4E89MzUeWaR8TRg@mail.gmail.com>
Viktor Bojovi*<viktor.bojovic@gmail.com> wrote:
> i don't know why it doesn't use index scan.
Because it thinks your query will return 81226 rows. We need more
information to make many suggestions beyond "make sure the table has
been analyzed".
http://wiki.postgresql.org/wiki/SlowQueryQuestions
Also, it's not considered good form to post an issue to more than
one PostgreSQL list. This is probably most appropriate on the
pgsql-performance list, so if you want to follow up with more detail
to get more detailed suggestions, it would be best to abandon this
thread and start a new one on that list.
-Kevin
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: Kevin.Grittner@wicourts.gov, viktor.bojovic@gmail.com, pgsql-admin@postgresql.org
Subject: Re: function based index problem
In-Reply-To: <4E5E672002000025000409E7@gw.wicourts.gov>
* 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