pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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)
> 
> 



view thread (6+ messages)  latest in thread

Message-ID: <413F1B85.9040302@speakeasy.net>
Permalink:  ../413F1B85.9040302@speakeasy.net/
Also on:    postgresql.org/message-id/413F1B85.9040302@speakeasy.net

 · 

reply

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