Hi Tom,
I don't believe I did run Analyze, I was under the assumption that the
statistics would have been up to date when the indexes were created.
Thanks for the quick response.
-mike
Tom Lane wrote:
> Michael Guerin <[EMAIL PROTECTED]> writes:
> > I just restored a database running on a solaris box to a linux box
> > and queries take forever to execute.
>
> Did you remember to run ANALYZE? Have you applied the same
> configuration settings that you were using before?
>
> regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
