| 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: | Whole Thread | Raw Message | 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 |