Nörder-Tuitje wrote:
Hi,
meanwhile I have received the hint to make postgres use the index via
SET ENABLE_SEQSCAN=FALSE;
which fits perfectly. The execution plan now indicates full use of
index.
What execution plan? I still only see one message on the list.
Nevertheless this is merely a workaround. Maybe the io-costs are
configured to cheap.
Possibly - the explain analyse will show you.
--
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