Re: match an IP address - Mailing list pgsql-general

From Craig Ringer
Subject Re: match an IP address
Date
Msg-id 48D8AAEB.2010103@postnewspapers.com.au
Whole thread Raw
In response to Re: match an IP address  ("Phoenix Kiula" <phoenix.kiula@gmail.com>)
Responses Re: match an IP address  ("Phoenix Kiula" <phoenix.kiula@gmail.com>)
List 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

pgsql-general by date:

Previous
From: "Dave Page"
Date:
Subject: Re: [ADMIN] 8.3.4 rpms for Opensuse10.3 64bit
Next
From: Simon Riggs
Date:
Subject: Re: [ADMIN] 8.3.4 rpms for Opensuse10.3 64bit