Thanks Tom,
I am using version 7.3.4, having problems updating to postgres 8 because of cpanel problems.
regarding,
>Evidently one has been analyzed much more recently than the other,because the estimated row counts are wildly different.
Both the explain/analyse queries has been run at the
the servers with subselect are way different. the loops and the query time are completely different. both servers have same indexes.
Any help will be greately appreciated..
Best Regards
Pankaj Naug
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
