Re: Problem with large query - Mailing list pgsql-performance

From Tom Lane
Subject Re: Problem with large query
Date
Msg-id 20149.1094654443@sss.pgh.pa.us
Whole thread Raw
In response to Problem with large query  (Marc Cousin <mcousin@sigma.fr>)
Responses Re: Problem with large query  (Marc Cousin <mcousin@sigma.fr>)
Re: Problem with large query  (Adam Sah <asah@speakeasy.net>)
List pgsql-performance
Marc Cousin <mcousin@sigma.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

pgsql-performance by date:

Previous
From: Marc Cousin
Date:
Subject: Problem with large query
Next
From: Marc Cousin
Date:
Subject: Re: Problem with large query