Re: indexes

From: Chris Ruprecht <chrup999(at)yahoo(dot)com>
To: isabelle(at)apartia(dot)fr
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: indexes
Date: 2002-02-05 17:50:52
Message-ID: p05101211b885cb366c7c@[192.168.0.6]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

  • indexes at 2002-02-05 17:05:25 from Isabelle Brette

Responses

  • Re: indexes at 2002-02-06 09:50:20 from Isabelle Brette

Browse pgsql-sql by date

  From Date Subject
Next Message Chris Ruprecht 2002-02-05 18:00:39 Re: WAL filling up disk
Previous Message Tom Lane 2002-02-05 17:28:16 Re: WAL filling up disk