Skip site navigation (1) Skip section navigation (2)

Re: SQL question....

From: Steve Midgley <public(at)misuse(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: SQL question....
Date: 2008-05-22 00:42:14
Message-ID: 20080522004916.300E42E002C@developer.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-sql
At 12:20 PM 5/21/2008, pgsql-sql-owner(at)postgresql(dot)org wrote:
>Date: Wed, 21 May 2008 06:39:11 -0500
>From: Karl Denninger <karl(at)denninger(dot)net>
>To: Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com>
>Cc: pgsql-sql(at)postgresql(dot)org
>Subject: Re: SQL question....
>Message-ID: <483409DF(dot)7050905(at)denninger(dot)net>
>
> > 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 


Responses

pgsql-sql by date

Next:From: Karl DenningerDate: 2008-05-22 01:12:34
Subject: Re: SQL question....
Previous:From: Karl DenningerDate: 2008-05-21 11:39:11
Subject: Re: SQL question....

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group