On Wed, Aug 31, 2011 at 11:53 PM, Kevin Grittner <Kevin.Grittner@xxxxxxxxxxxx> wrote:
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
"analyze entry" has solved the problem. Thanx a lot.
--
---------------------------------------
Viktor Bojović
---------------------------------------
Wherever I go, Murphy goes with me
