Postgres Pro
Downloads
Home   >   mailing lists

Re: Query optimisation on two machines is different. - Mailing list pgsql-general

From Tom Lane
Subject Re: Query optimisation on two machines is different.
Date
Msg-id 26610.971369209@sss.pgh.pa.us
Whole thread Raw
In response to Query optimisation on two machines is different.  (Martin Tomes <martin.tomes@controls.eurotherm.co.uk>)
List pgsql-general
Tree view 
Have you VACUUM ANALYZEd the table on both machines?

The difference in plan type is not unexpected given the radical
difference in estimated number of rows returned, and the row estimate
is derived from statistics gathered by vacuum analyze ...

            regards, tom lane

pgsql-general by date:

Previous
From: "Adam Lang"
Date:
Subject: Re: postgresql 7.1
Next
From: Bruce Momjian
Date:
Subject: Re: postgresql 7.1