Re: [PERFORM] COUNT(*) again (was Re: Index/Function organized table layout) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PERFORM] COUNT(*) again (was Re: Index/Function organized table layout)
Date
Msg-id 28313.1065334111@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PERFORM] COUNT(*) again (was Re: Index/Function organized  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: [PERFORM] COUNT(*) again (was Re: Index/Function organized
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Tom Lane wrote:
>> I think that's not happening, conditionally or otherwise.  The atomicity
>> problems alone are sufficient reason why not, even before you look at
>> the performance issues.

> What are the atomicity problems of adding a create/expire xid to the
> index tuples?

You can't update a tuple's status in just one place ... you have to
update the copies in the indexes too.

            regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Open 7.4 items
Next
From: Tom Lane
Date:
Subject: Re: Thoughts on maintaining 7.3