by the way, this reminds me: I just ran a performance study at a company doing
   an oracle-to-postgres conversion, and FYI converting from numeric and decimal
   to integer/bigint/real saved roughly 3x on space and 2x on performance.
   Obviously, YMMV.

adam


Tom Lane wrote:

Marc Cousin <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])



---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend

Reply via email to