Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id A99829FB298 for ; Mon, 29 Jan 2007 09:36:19 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 64050-04 for ; Mon, 29 Jan 2007 09:36:12 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.225]) by postgresql.org (Postfix) with ESMTP id 4D5129FB1DA for ; Mon, 29 Jan 2007 09:36:11 -0400 (AST) Received: by wr-out-0506.google.com with SMTP id 68so980171wra for ; Mon, 29 Jan 2007 05:36:10 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender; b=VRiYf6rlADy5xNqru7As2l8dXqn6vao6XQ7LB6uEaRGp9NcyoBZjKnO3A+8xUpvmMBFT03P0nRUFEoJJ57hX5mhMUZGZeMdD4Tvz0nb5mXYtkSmHoPOTnlnyuhFSCo1LUBMAlirZxmC78qiPyUfjgUwVZ1s3KyngpvcMjftvHU8= Received: by 10.78.106.3 with SMTP id e3mr4098796huc.1170077769628; Mon, 29 Jan 2007 05:36:09 -0800 (PST) Received: from ?172.24.32.59? ( [62.232.55.118]) by mx.google.com with ESMTP id 39sm7922916hug.2007.01.29.05.36.08; Mon, 29 Jan 2007 05:36:09 -0800 (PST) Message-ID: <45BDF82D.8010106@enterprisedb.com> Date: Mon, 29 Jan 2007 13:35:41 +0000 From: Heikki Linnakangas User-Agent: Icedove 1.5.0.8 (X11/20061116) MIME-Version: 1.0 To: arnaulist@andromeiberica.com CC: PostgreSQL Performance Subject: Re: [OT] Very strange postgresql behaviour References: <45BDE6E4.9050805@andromeiberica.com> In-Reply-To: <45BDE6E4.9050805@andromeiberica.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/402 X-Sequence-Number: 23003 Arnau wrote: > Hi all, > > I have postgresql 7.4.2 running on debian and I have the oddest > postgresql behaviour I've ever seen. You should upgrade. The latest 7.2 release is 7.4.15 > I do the following queries: > ... At first glance this looks like a bug in PostgreSQL, but.. > Rules: > > A lot of rules that I don't paste as matter of length. Is there any SELECT rules by chance that might explain this? -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com