Postgres Pro
Downloads
Home   >   mailing lists

Re: coalesce alternative - Mailing list pgsql-performance

From Bruno Wolff III
Subject Re: coalesce alternative
Date
Msg-id 20050403130411.GD27923@wolff.to
Whole thread Raw
In response to coalesce alternative  ("ALÝ ÇELÝK" <ali@verus.com.tr>)
List pgsql-performance
Tree view 
On Tue, Mar 29, 2005 at 14:21:13 +0300,
  ALÝ ÇELÝK <ali@verus.com.tr> 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.

pgsql-performance by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Delete query takes exorbitant amount of time
Next
From: mark.lubratt@indeq.com
Date:
Subject: Correcting Hash Join Estimates