Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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.

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group