Received: from smtp017.mail.yahoo.com (smtp017.mail.yahoo.com [216.136.174.114]) by postgresql.org (8.11.3/8.11.4) with SMTP id g15Holl32339 for ; Tue, 5 Feb 2002 12:50:47 -0500 (EST) (envelope-from chrup999@yahoo.com) Received: from chill-025.dfw.tx.bbnow.net (HELO ?192.168.0.6?) (24.219.2.25) by smtp.mail.vip.sc5.yahoo.com with SMTP; 5 Feb 2002 17:50:52 -0000 Mime-Version: 1.0 X-Sender: chrup999@pop.mail.yahoo.com Message-Id: In-Reply-To: <20020205170524.GA1990@aparima.com> References: <20020205170524.GA1990@aparima.com> Date: Tue, 5 Feb 2002 11:50:52 -0600 To: isabelle@apartia.fr From: Chris Ruprecht Subject: Re: indexes Cc: pgsql-sql@postgresql.org Content-Type: text/plain; charset="iso-8859-1" ; format="flowed" Content-Transfer-Encoding: 8bit X-Archive-Number: 200202/59 X-Sequence-Number: 6490 Isabella, I would do a create index sess_created on sessions (ip, to_char); This satisfies the where clause and might help in the group by. Best regards, Chris At 18:05 +0100 02/05/2002, Isabelle Brette wrote: >Hi everybody ^^ > [snip] -- Chris Ruprecht Network grunt and bit pusher extraordinaíre _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com