From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Jared Carr <jared(at)89glass(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Getting rid of duplicate tables. |
Date: | 2004-01-19 22:51:57 |
Message-ID: | 18931.1074552717@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Jared Carr <jared(at)89glass(dot)com> writes:
>> For starters, what PG version is this? And how many entries are there
>> in pg_class at the moment? (The output from "VACUUM VERBOSE pg_class"
>> would be useful to look at.)
> This is version 7.4.1 (upgraded from 7.4 about 3 weeks ago).
Okay, that shoots down my faint hope that this was an old bug. I am
growing increasingly suspicious that there is some corner-case problem
with duplicate rows in 7.4, because we've seen two or three reports now
of problems with unexpected duplicates. The reports all have different
symptoms but I sense a common theme ...
> And the contents of pg_class relating to this table.
>
> live=# select * from pg_class where relname='order_to_do';
I was just about to ask for that, but I need to see the system columns
too:
select oid,ctid,cmax,xmax,cmin,xmin,* from pg_class
where relname='order_to_do';
Also, would you check whether you get the same results from this query
with enable_indexscan switched off?
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Eckermann | 2004-01-19 22:57:51 | Re: 7.4 -> 7.4.1 upgrade with customization on freebsd |
Previous Message | Carlos Costa Portela | 2004-01-19 22:45:08 | Re: Great change (size of data dir) upgrading postgresql |