X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6B2355334B for ; Sun, 3 Apr 2005 13:47:22 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 49808-03 for ; Sun, 3 Apr 2005 12:47:20 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 101435333E for ; Sun, 3 Apr 2005 13:47:19 +0100 (BST) Received: (qmail 28699 invoked by uid 500); 3 Apr 2005 13:04:11 -0000 Date: Sun, 3 Apr 2005 08:04:11 -0500 From: Bruno Wolff III To: =?iso-8859-1?B?QUzdIMdFTN1L?= Cc: pgsql-performance@postgresql.org Subject: Re: coalesce alternative Message-ID: <20050403130411.GD27923@wolff.to> Mail-Followup-To: Bruno Wolff III , =?iso-8859-1?B?QUzdIMdFTN1L?= , pgsql-performance@postgresql.org References: Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.01 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/41 X-Sequence-Number: 11438 On Tue, Mar 29, 2005 at 14:21:13 +0300, ALİ ÇELİK wrote: > I have used coalesce function for null fields but coalesce is too slow. > I need fast alternative for coalesce It is unlikely that coalesce is your problem. People might be able to provide some help if you provide EXPLAIN ANALYZE output and the actual query for your slow query.