Re: Increasing GROUP BY CHAR columns speed

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: "Scott Carey" <scott(at)richrelevance(dot)com>, "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Increasing GROUP BY CHAR columns speed
Date: 2008-11-28 20:43:57
Message-ID: 2B43ECEF2E3A49A1811782BD8FD8E67E@andrusnotebook
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>I it seems that slowness is caused by grouping by column
>
> exchrate numeric(13,8)

exchrate has different values in few rows.
It has usually value 0
In this sample query it is always 0.

I tried not change exchrate with

nullif( bilkaib.EXCHRATE,0)

but this does not up speed query, no idea why.

Andrus.

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2008-11-28 22:28:42 Re: Memory Allocation
Previous Message Scott Marlowe 2008-11-28 20:34:29 Re: Increasing GROUP BY CHAR columns speed