Re: bug in query planning? - Mailing list pgsql-general

From Steven D.Arnold
Subject Re: bug in query planning?
Date
Msg-id 1EF0A108-37D8-11D8-87ED-000A95BA4396@neosynapse.net
Whole thread Raw
In response to Re: bug in query planning?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Thanks to all for the detailed replies.  I just wanted to let everyone
know -- for future google searches as much as anything else -- that
dumping the database, upgrading to 7.4.1 and reloading did solve the
problem.  All the queries I mentioned now use the available indices,
except for understandable cases such as the number of rows in a table
being really small.

Thanks for the tip and thanks for the improvements in 7.4.1 that fixed
this problem.

steve


pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Is my MySQL Gaining ?
Next
From: Tom Lane
Date:
Subject: Re: between