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 13:55:09
Message-ID: 21524.1087394109@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:
> rt2=# SELECT name from users group by name having count(*) > 1 limit 20;
> (4 rows)
> rt2=# SELECT name from users group by name having count(*) > 1 ;
> (0 rows)

Weird. What PG version is this? What does EXPLAIN show for each of
these queries (maybe EXPLAIN ANALYZE too)? Can you provide a
self-contained test case?

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message C. Bensend 2004-06-16 14:37:58 Re: VARCHAR -vs- CHAR: huge performance difference?
Previous Message Harry 2004-06-16 13:00:07 cygwin installation problem (windows platform)