Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 6C9A92E0048 for ; Mon, 7 Apr 2008 16:38:56 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 81757-04 for ; Mon, 7 Apr 2008 16:38:53 -0300 (ADT) X-Greylist: delayed 00:45:10.747525 by SQLgrey-1.7.5 Received: from mail.enyo.de (mail.enyo.de [212.9.189.167]) by developer.postgresql.org (Postfix) with ESMTP id 2CA5D2E005D for ; Mon, 7 Apr 2008 16:38:53 -0300 (ADT) Received: from deneb.vpn.enyo.de ([212.9.189.177] helo=deneb.enyo.de) by mail.enyo.de with esmtp id 1JiwTK-0001wB-BM; Mon, 07 Apr 2008 20:53:38 +0200 Received: from fw by deneb.enyo.de with local (Exim 4.69) (envelope-from ) id 1JiwTJ-0006O5-QW; Mon, 07 Apr 2008 20:53:37 +0200 From: Florian Weimer To: Dimi Paun Cc: pgsql-performance@postgresql.org Subject: Re: Severe performance problems for simple query References: <1207581719.5399.119.camel@dimi.lattica.com> Date: Mon, 07 Apr 2008 20:53:37 +0200 In-Reply-To: <1207581719.5399.119.camel@dimi.lattica.com> (Dimi Paun's message of "Mon, 07 Apr 2008 11:21:59 -0400") Message-ID: <87lk3plcni.fsf@mid.deneb.enyo.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/71 X-Sequence-Number: 29564 * Dimi Paun: > * 4.9 million records in a table (IP address info) You should use the ip4r type for that.