Received: from nevald.k-net.dk (nevald.k-net.dtu.dk [130.225.71.226]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0JArN096427 for ; Fri, 19 Jan 2001 05:53:23 -0500 (EST) (envelope-from Nikolaj@kampsax.dtu.dk) Received: from carlsberg.kampsax.dtu.dk (carlsberg.kampsax.dtu.dk [192.38.212.2]) by nevald.k-net.dk (Postfix) with SMTP id 5ACEEBFAC for ; Fri, 19 Jan 2001 11:53:20 +0100 (CET) Received: (qmail 1060 invoked from network); 19 Jan 2001 10:53:20 -0000 Received: from commando.kampsax.dtu.dk (HELO commando) (192.38.212.143) by carlsberg.kampsax.dtu.dk with SMTP; 19 Jan 2001 10:53:20 -0000 Message-ID: <001501c08206$57555a40$8fd426c0@commando.kampsax.dtu.dk> Reply-To: "Nikolaj Lundsgaard" From: "Nikolaj Lundsgaard" To: Subject: Indices Date: Fri, 19 Jan 2001 11:55:31 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by mail.postgresql.org id f0JArN096428 X-Archive-Number: 200101/252 X-Sequence-Number: 921 Maybe a wrong mailinglist to ask this, but... Are there any plans on writing a chapter in the documentation about the implementation of indices. I know from M$ SQL Server that it is no picnic determining which indices are useful, and thick books can be written on how to make the right indices for the right query. I have no idea if postgres has similar strange ways of using indices, but even so, that should be written in the documentation. However I find it highly probable that I am not the only one having trouble designing indices. Often I see questions on this mailinglist sounding like: "Why is my query not using the index". These would perhaps be less frequent in the future if such a chapter was written. Have a nice week-end Regards, Nikolaj