Nachricht-
Von: Richard Huxton [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 13. Oktober 2005 12:22
An: Nörder-Tuitje, Marcus
Cc: pgsql-performance@postgresql.org
Betreff: Re: [PERFORM] Optimizer misconfigured ?
Nörder-Tuitje wrote:
Hello,
I have a strange effect on upcoming structure
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
Nörder-Tuitje wrote:
Hello,
I have a strange effect on upcoming structure :
People will be wanting the output of EXPLAIN ANALYSE on that query.
They'll also ask whether you've VACUUMed, ANALYSEd and configured your
postgresql.conf correctly.
--
Richard Huxton
Archonet Ltd
