Postgres Pro
Downloads
Home   >   mailing lists

Re: Index tuple count != heap tuple count problem identified] - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Index tuple count != heap tuple count problem identified]
Date
Msg-id 25824.954997222@sss.pgh.pa.us
Whole thread Raw
In response to RE: Index tuple count != heap tuple count problem identified]  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
List pgsql-hackers
Tree view 
"Hiroshi Inoue" <Inoue@tpf.co.jp> writes:
>>>> Is it wrong to change the implementation of CREATE INDEX ?
>>>> I have a fix.
>>>> It needs the change of duplicate check(tuplesort->btbuild) and
>>>> I've thougth that it would be better to change it after the release
>>>> of 7.0.
>> 
>> Well, it seems we better do something about it before 7.0 is released.
>> Now it seems we have to decide to change CREATE INDEX, or modify VACUUM.

> It's difficult for me to provide a fix for CREATE INDEX before 7.0 is
> released.
> It's not sufficiently checked and I don't remember details now.

Also, we'd need to change the other index access methods too.  That
doesn't seem to me like a good thing to tackle a week before release...
        regards, tom lane

pgsql-hackers by date:

Previous
From: "Hiroshi Inoue"
Date:
Subject: RE: Index tuple count != heap tuple count problem identified]
Next
From: Tatsuo Ishii
Date:
Subject: Re: Doc updates