Обсуждение: postgresql performance on linux port

   I just restored a database running on a solaris box to a linux box
and queries take forever to execute.  The linux box is faster and has
twice the memory allocated to postgresql, is there anything obvious that
I should look at?  It is using a journal file system.

Michael Guerin <guerin@rentec.com> 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

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 <guerin@rentec.com> 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