Re: Problem with large query

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