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

From: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: weired behavior... after pg_resetxlog-> dump->initdb-->reload.
Date: 2004-06-16 07:53:12
Message-ID: 40CFFC68.5090704@trade-india.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I recovered my database by pg_resetxlog and then did a dump , initdb ,
reload.
one of the tables exhibited this phenomenon. I thought it was worth
mentioning
to the developers.

Regds
mallah.

rt2=# SELECT name from users group by name having count(*) > 1 limit 20;

+----------------------+
| name |
+----------------------+
| �˾ |
| ����163.com |
| �(at)hotmail(dot)com |
| p� |
+----------------------+
(4 rows)

Time: 1961.199 ms
rt2=#
rt2=# SELECT name from users group by name having count(*) > 1 ;
+------+
| name |
+------+
+------+
(0 rows)

Time: 789.184 ms

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message lise chhay 2004-06-16 09:00:30 problem of the programme htg
Previous Message Scott Marlowe 2004-06-16 05:31:11 Re: VARCHAR -vs- CHAR: huge performance difference?