Re: Query optimisation on two machines is different.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Martin Tomes <martin(dot)tomes(at)controls(dot)eurotherm(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Query optimisation on two machines is different.
Date: 2000-10-12 16:46:49
Message-ID: 26610.971369209@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2000-10-12 16:46:54 Re: postgresql 7.1
Previous Message Adam Lang 2000-10-12 16:46:18 Re: postgresql 7.1