Re: weired behavior... after pg_resetxlog-> dump->initdb-->reload.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: weired behavior... after pg_resetxlog-> dump->initdb-->reload.
Date: 2004-06-16 15:35:10
Message-ID: 22477.1087400110@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Rajesh Kumar Mallah <mallah(at)trade-india(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2004-06-16 15:54:06 Re: weired behavior... after pg_resetxlog-> dump->initdb-->reload.
Previous Message Rajesh Kumar Mallah 2004-06-16 15:00:38 Re: weired behavior... after pg_resetxlog-> dump->initdb-->reload.