Received: from front5.grolier.fr (front5.grolier.fr [194.158.96.55]) by hub.org (8.9.2/8.9.1) with ESMTP id TAA98977 for ; Mon, 8 Feb 1999 19:32:38 -0500 (EST) (envelope-from fabrice.scemama@gesnet.net) Received: from gesnet.net (ppp-164-254.villette.club-internet.fr [195.36.164.254]) by front5.grolier.fr (8.9.0/8.9.2) with ESMTP id BAA14446 for ; Tue, 9 Feb 1999 01:32:34 +0100 (MET) Message-ID: <36BF80B3.62B55848@gesnet.net> Date: Tue, 09 Feb 1999 01:26:28 +0100 From: Fabrice Scemama Organization: GESNET Consulting X-Mailer: Mozilla 4.5 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 CC: PgSQL-sql Subject: Using Indexes with Pg References: <017801be515a$6e964180$a3f0f6ce@bryan.arcamax.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi people; I'm not sure my question is in topic, and if it's not please don't reply that mail on the list. What's the best way to use indexes (indices ?) with Pg ? Is it possible to have simple examples showing when it's interesting to create an index, and when it's not ? Are there some particular things to know regarding the way Pg works with indexes ? Thanks. Fabrice Scemama