Re: Problem with large query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marc Cousin <mcousin(at)sigma(dot)fr>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Problem with large query
Date: 2004-09-08 14:40:43
Message-ID: 20149.1094654443@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Marc Cousin <mcousin(at)sigma(dot)fr> writes:
> I'm having trouble with a (quite big) query, and can't find a way to make it
> faster.

Seems like it might help if the thing could use a HashAggregate instead
of sort/group. Numeric is not hashable, so having those TO_NUMBER
constants in GROUP BY destroys this option instantly ... but why in the
world are you grouping by constants anyway? You didn't say what the
datatypes of the other columns were...

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Adam Sah 2004-09-08 14:47:33 Re: Problem with large query
Previous Message Marc Cousin 2004-09-08 13:49:49 Problem with large query