Re: index for inet and >> (contains) function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard Jones <rich(at)annexia(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: index for inet and >> (contains) function
Date: 2006-03-22 17:08:11
Message-ID: 17497.1143047291@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Richard Jones <rich(at)annexia(dot)org> writes:
> select countryid from iptocountry where network >> '1.2.3.4';

> Is there a suitable index that I can put on the network field to fix
> this?

Not at the moment :-(. I think it might be possible to write a GIST
opclass that could handle this, but there's not one there today.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas F. O'Connell 2006-03-22 17:10:20 Re: Autovacuum Daemon Disrupting dropdb?
Previous Message Vivek Khera 2006-03-22 16:53:43 Re: Advantages of PostgreSQL over MySQL 5.0