At 02:58 PM 21/11/2002 +0100, Roel Rozendaal - IC&S wrote:
On my mac, the installation was just for trying to port dbmail to OS X.
The database contains 6 messages making a total size of 220 bytes for 1
user; no updates or changes.
This is not necessarily odd; on an empty database it may well choose the
specified 'bad' strategy because it is, AFAICT, not a bad strategy when the
DB is empty.
It is possible that the fact the ANALYZE has not been run on the large DB
means that it is still planning as if the database is empty.
I have confirmed that I get the same strategy as you on an empty DB; I
think you should run an ANALYZE then try the query again. We run an analyze
every night.
----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 03 5330 3172 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/
