Mark Kirkwood wrote:
8.2 is deciding to use a bitmap index scan on taskid_taskinstance_key,
which seems to be slower (!) than a plain old index scan that 8.0 is
using. A dirty work around is to disable bitmap scans via:
I'm having difficulty figuring out why it's doing this at all. There's
only one index involved, and it's over the primary-key to boot!
An EXPLAIN ANALYSE with enable_bitmapscan off should say why PG thinks
the costs are cheaper than they actually are.
PS - well worded question Kurt. All the relevant information neatly laid
out, explain analyse on both platforms - you should be charging to let
people help ;-)
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
