Re: [COMMITTERS] pgsql-server/ oc/src/sgml/runtime.sgml rc/back ... - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [COMMITTERS] pgsql-server/ oc/src/sgml/runtime.sgml rc/back ...
Date
Msg-id 200211210104.gAL146e27249@candle.pha.pa.us
Whole thread Raw
Responses Re: [COMMITTERS] pgsql-server/ oc/src/sgml/runtime.sgml rc/back ...  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> Log message:
>     Finish implementation of hashed aggregation.  Add enable_hashagg GUC
>     parameter to allow it to be forced off for comparison purposes.
>     Add ORDER BY clauses to a bunch of regression test queries that will
>     otherwise produce randomly-ordered output in the new regime.

Tom, do we really want to add a GUC that is used just for comparison of
performance?  I know we have the seqscan on/off, but there are valid
reasons to do that.  Do you think there will be cases where it will
faster to have this hash setting off?

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Rod Taylor
Date:
Subject: Re: [GENERAL] Bug with sequence
Next
From: Justin Clift
Date:
Subject: Re: [GENERAL] Bug with sequence