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
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
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.
--
