Re: match an IP address

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To:
Cc: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: match an IP address
Date: 2008-09-23 08:38:03
Message-ID: 48D8AAEB.2010103@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Phoenix Kiula wrote:

> Ever tried this crap on a table of 10 million records on a live
> website, where this query is happening at 3000 times per second? No
> such function schtick will match the raw speed of a simpler indexed
> query. Or did you mean my index should contain the COALESCE already?

Please forgive my attempt to help you based on a woefully insufficient
description of your problem and situation. I will not make any attempt
to do so again.

--
Craig Ringer

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Simon Riggs 2008-09-23 08:49:17 Re: [GENERAL] 8.3.4 rpms for Opensuse10.3 64bit
Previous Message Michelle Konzack 2008-09-23 08:12:30 Re: PDF Documentation for 8.3?