Postgres Pro
Downloads
Home   >   mailing lists

Re: weired behavior... after pg_resetxlog-> dump->initdb-->reload. - Mailing list pgsql-admin

From Tom Lane
Subject Re: weired behavior... after pg_resetxlog-> dump->initdb-->reload.
Date
Msg-id 22477.1087400110@sss.pgh.pa.us
Whole thread Raw
In response to Re: weired behavior... after pg_resetxlog-> dump->initdb-->reload.  (Rajesh Kumar Mallah <mallah@trade-india.com>)
Responses Re: weired behavior... after pg_resetxlog-> dump->initdb-->reload.  (Rajesh Kumar Mallah <mallah@trade-india.com>)
List pgsql-admin
Tree view 
Rajesh Kumar Mallah <mallah@trade-india.com> writes:
> here is something which was the original problem
> and is replicable.

Hm.  Does EXPLAIN show that the GROUP BY query is using hash
aggregation?  Does its behavior change if you turn off enable_hashagg?

            regards, tom lane

pgsql-admin by date:

Previous
From: Rajesh Kumar Mallah
Date:
Subject: Re: weired behavior... after pg_resetxlog-> dump->initdb-->reload.
Next
From: Rajesh Kumar Mallah
Date:
Subject: Re: weired behavior... after pg_resetxlog-> dump->initdb-->reload.