Received: from front3.grolier.fr (front3.grolier.fr [194.158.96.53]) by hub.org (8.9.2/8.9.1) with ESMTP id AAA90413 for ; Wed, 10 Feb 1999 00:31:48 -0500 (EST) (envelope-from fabrice.scemama@gesnet.net) Received: from gesnet.net (ppp-162-203.villette.club-internet.fr [195.36.162.203]) by front3.grolier.fr (8.9.0/8.9.2) with ESMTP id GAA04074 for ; Wed, 10 Feb 1999 06:31:38 +0100 (MET) Message-ID: <36C117C1.EB91F528@gesnet.net> Date: Wed, 10 Feb 1999 06:23:13 +0100 From: Fabrice Scemama Organization: GESNET Consulting X-Mailer: Mozilla 4.5 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgreSQL.org Subject: [Fwd: [SQL] Using Indexes with Pg]IamReal. Content-Type: multipart/mixed; boundary="------------CE62BBC6328F8C7D5F3253F3" This is a multi-part message in MIME format. --------------CE62BBC6328F8C7D5F3253F3 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit --------------CE62BBC6328F8C7D5F3253F3 Content-Type: message/rfc822; name="nsmail5I.TMP" Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="nsmail5I.TMP" Return-Path: Received: from web5.prometeus.net ([209.207.141.46]) by pan.host4u.net (8.8.5/8.8.5) with ESMTP id SAA01776 for ; Mon, 8 Feb 1999 18:46:11 -0600 Received: (from gesnet@localhost) by web5.prometeus.net (8.9.1/8.9.1) id TAA14228 for siege-social@siege-social.com; Mon, 8 Feb 1999 19:45:58 -0500 (EST) Received: from grizzly.fas.com (cc69528-a.mtpls1.sc.home.com [24.1.39.17]) by web5.prometeus.net (8.9.1/8.9.1) with ESMTP id TAA14062 for ; Mon, 8 Feb 1999 19:45:45 -0500 (EST) Message-Id: <199902090045.TAA14062@web5.prometeus.net> Received: by grizzly.fas.com ($Revision: 1.37.109.23 $/16.2) id AA144221152; Mon, 8 Feb 1999 19:45:52 -0500 Date: Mon, 8 Feb 1999 19:45:52 -0500 To: fabrice.scemama@gesnet.net Subject: Re: [SQL] Using Indexes with Pg References: <017801be515a$6e964180$a3f0f6ce@bryan.arcamax.com> <36BF80B3.62B55848@gesnet.net> In-Reply-To: <36BF80B3.62B55848@gesnet.net> X-Loop: login@otherdomain.com From: login@otherdomain.com X-Mozilla-Status2: 00000000 ===== AUTOMATIC NOTICE ===== Your mail (attached below this notice) either came from an Internet site which is on my filter's list of sites which have problems with unsolicited bulk email (aka UCE or spam), or had headers or body text which looked like spam to the filter, so the filter intercepted it. If you are a bulk mailer, advertiser (commercial or political), or are sending any kind of "free offer", please remove this address from your mailing list and do not email me again. If you are not an advertiser or bulk mailer, you can resend your mail and get past the filters by including the password listed below on the Subject: line of your message. It can appear anywhere on the Subject: line -- it doesn't have to be first, last, or the only thing on that line. An easy way to do this is to forward this bounced message back to me and either change the Subject: line to the password, or add it to the beginning or end of the Subject: line, whatever is easier. Thank you! ********** The password is IamReal. ********** =-=-=-=-=-=-=-=-=-= From owner-pgsql-sql@hub.org Mon Feb 8 19:44:29 1999 Received: from awod.com (grizzly.fas.com) by grizzly.fas.com with ESMTP ($Revision: 1.37.109.23 $/16.2) id AA142431021; Mon, 8 Feb 1999 19:43:42 -0500 Return-Path: Received: from hub.org (majordom@hub.org [209.47.145.100]) by sumter.awod.com (8.8.7/8.8.8) with ESMTP id TAA21728 for ; Mon, 8 Feb 1999 19:42:42 -0500 (EST) (envelope-from owner-pgsql-sql@hub.org) Received: from localhost (majordom@localhost) by hub.org (8.9.2/8.9.1) with SMTP id TAA99021; Mon, 8 Feb 1999 19:32:55 -0500 (EST) (envelope-from owner-pgsql-sql@hub.org) Received: by hub.org (TLB v0.10a (1.23 tibbs 1997/01/09 00:29:32)); Mon, 08 Feb 1999 19:32:49 +0000 (EST) Received: (from majordom@localhost) by hub.org (8.9.2/8.9.1) id TAA98994 for pgsql-sql-outgoing; Mon, 8 Feb 1999 19:32:46 -0500 (EST) (envelope-from owner-pgsql-sql@postgreSQL.org) 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: [SQL] Using Indexes with Pg References: <017801be515a$6e964180$a3f0f6ce@bryan.arcamax.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-pgsql-sql@postgreSQL.org Precedence: bulk X-Uidl: 309d81a0bfe50154bee4f5a6f1c85a96 X-SpamBouncer: 1.00h (2/03/99) X-SBRule: BULKTAG X-SBRule: Missing To: 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 --------------CE62BBC6328F8C7D5F3253F3--