Re: postgresql performance on linux port - Mailing list pgsql-performance

From Michael Guerin
Subject Re: postgresql performance on linux port
Date
Msg-id 3FE78D61.2F0AECAD@rentec.com
Whole thread Raw
In response to postgresql performance on linux port  (Michael Guerin <guerin@rentec.com>)
List pgsql-performance
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


pgsql-performance by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: mnogosearch under 7.4 ...
Next
From: "Michael Rothschild"
Date:
Subject: