From: Adam Sah <asah@speakeasy.net>
To: pgsql-performance@postgresql.org
Subject: Re: Problem with large query
Date: Wed, 08 Sep 2004 07:47:33 -0700
Message-ID: <413F1B85.9040302@speakeasy.net> (raw)
In-Reply-To: <20149.1094654443@sss.pgh.pa.us>
References: <200409081549.49537.mcousin@sigma.fr>
<20149.1094654443@sss.pgh.pa.us>
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 <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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: asah@speakeasy.net
Subject: Re: Problem with large query
In-Reply-To: <413F1B85.9040302@speakeasy.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox