On Sun, 2005-04-10 at 07:54 -0700, pankaj naug wrote:
> [quoting Tom]
> >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 same time.
in that case, is the data the
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
pankaj naug <[EMAIL PROTECTED]> writes:
> Both servers have same version with same postgresql.conf. But the time taken
> by both the servers with subselect are way different. the loops and the query
> time are completely different. both servers have same indexes.
Evidently one has been analyzed
