Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 91B902E012E for ; Thu, 10 Jan 2008 19:18:34 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 46865-06 for ; Thu, 10 Jan 2008 19:18:27 -0400 (AST) Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id 5FA362E0187 for ; Thu, 10 Jan 2008 19:18:27 -0400 (AST) Received: from localhost (or-69-34-217-90.sta.embarqhsd.net [69.34.217.90]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m0ANIWPT010292 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Thu, 10 Jan 2008 15:18:32 -0800 Date: Thu, 10 Jan 2008 15:22:45 -0800 From: "Joshua D. Drake" To: Kevin Kempter Cc: pgsql-performance@postgresql.org Subject: Re: Best way to index IP data? Message-ID: <20080110152245.47c959da@commandprompt.com> In-Reply-To: <200801101614.54729.kevin@kevinkempterllc.com> References: <200801101614.54729.kevin@kevinkempterllc.com> Organization: Command Prompt, Inc. X-Mailer: Claws Mail 3.0.2 (GTK+ 2.12.0; x86_64-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: base64 X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Thu, 10 Jan 2008 15:18:33 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/59 X-Sequence-Number: 28298 LS0tLS1CRUdJTiBQR1AgU0lHTkVEIE1FU1NBR0UtLS0tLQ0KSGFzaDogU0hBMQ0KDQpPbiBUaHUs IDEwIEphbiAyMDA4IDE2OjE0OjU0IC0wNzAwDQpLZXZpbiBLZW1wdGVyIDxrZXZpbkBrZXZpbmtl bXB0ZXJsbGMuY29tPiB3cm90ZToNCg0KPiBIaSBMaXN0Ow0KPiANCj4gV2UnbGwgYmUgbG9hZGlu ZyBhIHRhYmxlIHdpdGggYmVnaW5pbmcgJiBlbmRpbmcgSS5QLidzIC0gdGhlIHRhYmxlDQo+IHdp bGwgbGlrZWx5IGhhdmUgdXB3YXJkcyBvZiAzMG1pbGxpb24gcm93cy4gIEFueSB0aG91Z2h0cyBv biBob3cgdG8NCj4gZ2V0IHRoZSBiZXN0IHBlcmZvcm1hbmNlIG91dCBvZiBxdWVyaWVzIHRoYXQg d2FudCB0byBsb29rIGZvciBJUA0KPiByYW5nZXMgb3IgdGhlIHVzZSBvZiBiZXR3ZWVuIHF1ZXJp ZXM/IFNob3VsZCB0aGVzZSBiZSBtb2RlbGVkIGFzDQo+IGludGVnZXJzPyANCj4gDQoNCmh0dHA6 Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy9jdXJyZW50L3N0YXRpYy9kYXRhdHlwZS1uZXQtdHlw ZXMuaHRtbA0KDQo+IFRoYW5rcyBpbiBhZHZhbmNlDQo+IA0KPiAvS2V2aW4NCj4gDQo+IC0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLShlbmQgb2YNCj4gYnJvYWRjYXN0KS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLSBUSVAgMTogaWYgcG9zdGluZy9yZWFkaW5nDQo+IHRocm91Z2ggVXNlbmV0 LCBwbGVhc2Ugc2VuZCBhbiBhcHByb3ByaWF0ZSBzdWJzY3JpYmUtbm9tYWlsIGNvbW1hbmQNCj4g dG8gbWFqb3Jkb21vQHBvc3RncmVzcWwub3JnIHNvIHRoYXQgeW91ciBtZXNzYWdlIGNhbiBnZXQg dGhyb3VnaCB0bw0KPiB0aGUgbWFpbGluZyBsaXN0IGNsZWFubHkNCj4gDQoNCg0KLSAtLSANClRo ZSBQb3N0Z3JlU1FMIENvbXBhbnk6IFNpbmNlIDE5OTcsIGh0dHA6Ly93d3cuY29tbWFuZHByb21w dC5jb20vIA0KU2FsZXMvU3VwcG9ydDogKzEuNTAzLjY2Ny40NTY0ICAgMjR4Ny9FbWVyZ2VuY3k6 ICsxLjgwMC40OTIuMjI0MA0KRG9uYXRlIHRvIHRoZSBQb3N0Z3JlU1FMIFByb2plY3Q6IGh0dHA6 Ly93d3cucG9zdGdyZXNxbC5vcmcvYWJvdXQvZG9uYXRlDQpTRUxFQ1QgJ1RyYWluaW5nJywgJ0Nv bnN1bHRpbmcnIEZST00gdmVuZG9yIFdIRVJFIG5hbWUgPSAnQ01EJw0KDQoNCi0tLS0tQkVHSU4g UEdQIFNJR05BVFVSRS0tLS0tDQpWZXJzaW9uOiBHbnVQRyB2MS40LjYgKEdOVS9MaW51eCkNCg0K aUQ4REJRRkhocWpIQVRiL3pxZlpVVVFSQXZNT0FKOTg0TnA1R01yRmQxdml4UC96RUNJbDNxVVdZ Z0NmZjZVNA0KYkNCQnoxVmF4cUlvWmZDRmZLRUlaTFU9DQo9Kzl2RA0KLS0tLS1FTkQgUEdQIFNJ R05BVFVSRS0tLS0tDQo=