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.


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

Reply via email to