Postgres Pro
Downloads
Home   >   mailing lists

Re: Increasing GROUP BY CHAR columns speed - Mailing list pgsql-performance

From Andrus
Subject Re: Increasing GROUP BY CHAR columns speed
Date
Msg-id 2B43ECEF2E3A49A1811782BD8FD8E67E@andrusnotebook
Whole thread Raw
In response to Increasing GROUP BY CHAR columns speed  ("Andrus" <kobruleht2@hot.ee>)
List pgsql-performance
Tree view 
>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:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Increasing GROUP BY CHAR columns speed
Next
From: "Kevin Grittner"
Date:
Subject: Re: Memory Allocation