Re: A thought on Index Organized Tables - Mailing list pgsql-hackers

From Gokulakannan Somasundaram
Subject Re: A thought on Index Organized Tables
Date
Msg-id 9362e74e1002250302r51ba91a7q5aa8c1bf14c6a6d8@mail.gmail.com
Whole thread Raw
In response to Re: A thought on Index Organized Tables  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: A thought on Index Organized Tables
List pgsql-hackers

Yes. When a bit is cleared, that's OK, because a cleared bit just means
"you need to check visibility in the heap tuple". When a bit is set,
however, it's important that it doesn't hit the disk before the
corresponding heap page update. That's why visibilitymap_set() sets the
LSN on the page.

OK. Say a session doing the update, which is the fist update on the page, resets the PD_ALL_VISIBLE and just before updating the visibility map crashes. The subsequent inserts/updates/deletes, will see the PD_ALL_VISIBLE flag cleared and never care to update the visibility map, but actually it would have created tuples in index and table. So won't this return wrong results?

Again it is not clear from your documentation, how you have handled this situation?

Thanks,
Gokul.
 

pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: testing cvs HEAD - HS/SR - xlog timeline 0 pg_xlogfile_name_offset
Next
From: Gokulakannan Somasundaram
Date:
Subject: Re: A thought on Index Organized Tables