From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Cc: | bright(at)ns1(dot)wintelcom(dot)net |
Subject: | [6.5.2] potentially major bug? |
Date: | 2000-01-28 03:28:43 |
Message-ID: | Pine.BSF.4.21.0001272322010.555-100000@thelab.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Okay, I don't know if this has been fixed in 7.0, but:
webcounter=> drop index webhit_referer_raw_url;
DROP
webcounter=> create index webhit_referer_raw_url on webhit_referer_raw using btree ( referrer_url );
CREATE
webcounter=> vacuum verbose webhit_referer_raw;
NOTICE: --Relation webhit_referer_raw--
NOTICE: Pages 7910: Changed 3, Reapped 2192, Empty 0, New 0; Tup 547520: Vac 43402, Keep/VTL 0/0, Crash 0, UnUsed 4871, MinLen 60, MaxLen 312; Re-using: Free/Avail. Space 4388524/4361716; EndEmpty/Avail. Pages 0/915. Elapsed 0/0 sec.
NOTICE: Index webhit_referer_raw_url: Pages 5048; Tuples 547400: Deleted 0. Elapsed 0/2 sec.
NOTICE: Index webhit_referer_raw_url: NUMBER OF INDEX' TUPLES (547400) IS NOT THE SAME AS HEAP' (547520)
ERROR: Invalid XID in t_cmin
Thoughts? Is this something that is fixed in 7.0 right now? This is a
semi-production system right now, so the loss of information would be most
unfortunate :(
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-01-28 03:35:49 | Re: [HACKERS] [6.5.3] 'attribute not found' |
Previous Message | Jeff MacDonald <jeff@pgsql.com> | 2000-01-28 03:07:59 | Re: [HACKERS] Spinlock error |