X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id A753ED1CCD2 for ; Mon, 15 Mar 2004 18:55:02 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 32556-05 for ; Mon, 15 Mar 2004 14:54:54 -0400 (AST) Received: from mailhost3.tudelft.nl (mailhost3.tudelft.nl [130.161.180.14]) by svr1.postgresql.org (Postfix) with ESMTP id 19063D1B909 for ; Mon, 15 Mar 2004 14:54:53 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by rav.antivirus (Postfix) with ESMTP id 08A9B2F0F3; Mon, 15 Mar 2004 19:54:53 +0100 (MET) Received: from listserv.tudelft.nl (listserv.tudelft.nl [130.161.180.33]) by mailhost3.tudelft.nl (Postfix) with ESMTP id C2F622F0EF; Mon, 15 Mar 2004 19:54:52 +0100 (MET) Received: from vulcanus.its.tudelft.nl (x193056-2.shuis-s.tudelft.nl [145.94.193.58]) by listserv.tudelft.nl (8.12.10/8.12.8) with ESMTP id i2FIspDR012101; Mon, 15 Mar 2004 19:54:52 +0100 (MET) Message-ID: <4055FBDD.1020207@vulcanus.its.tudelft.nl> Date: Mon, 15 Mar 2004 19:54:21 +0100 From: Arjen van der Meijden User-Agent: Mozilla Thunderbird 0.5 (Windows/20040207) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Greg Stark Cc: pgsql-performance@postgresql.org Subject: Re: Large CASE-statement is pretty slow? References: <4054B36C.8030306@vulcanus.its.tudelft.nl> <87y8q22fr2.fsf@stark.xeocode.com> In-Reply-To: <87y8q22fr2.fsf@stark.xeocode.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at tudelft.nl X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/196 X-Sequence-Number: 6052 Greg Stark wrote: > Arjen van der Meijden writes: > > > Was this the select with the CASE, or the update? It was just the select to see how long it'd take. I already anticipated it to be possibly a "slow query", so I only did the select first. Best regards, Arjen van der Meijden