At 12:20 PM 5/21/2008, [EMAIL PROTECTED] wrote:
Date: Wed, 21 May 2008 06:39:11 -0500
From: Karl Denninger <[EMAIL PROTECTED]>
To: Gurjeet Singh <[EMAIL PROTECTED]>
Cc: pgsql-sql@postgresql.org
Subject: Re: SQL question....
Message-ID: <[EMAIL PROTECTED]>
> Also, if you don't have it already, you may create an index on IP
> column for better performance.
> Mail sent from my BlackLaptop device
Its a very large table and is indexed already...
Not to completely beat this thing to death, but are you using an inet
or other custom datatype for this? I think if you index ip's using a
custom data type and search/group for specific octets, you'll get much
better performance than just searching via a regular b-tree string
index..
http://www.postgresql.org/docs/8.3/static/datatype-net-types.html
Steve
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
