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 9362e74e1002240816w41c62e26q1cd5fbcda1ba0aaa@mail.gmail.com
Whole thread Raw
In response to Re: A thought on Index Organized Tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: A thought on Index Organized Tables  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
<div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt
0pt0pt 0.8ex; padding-left: 1ex;"><br /> With an IOT I don't understand how you get out of index corruption<br />
withoutdata loss.  That's a showstopper for practical use, I think.<br /></blockquote></div><br />For simplicity, say
weare storing all the non-leaf pages of the index in a seperate file, then the leaf pages are nothing but the table. So
ifwe can replicate the table, then we can replicate the non-leaf pages (say by some modified version of reindex).<br
/><br/>Thanks,<br />Gokul.<br /> 

pgsql-hackers by date:

Previous
From: Gokulakannan Somasundaram
Date:
Subject: Re: A thought on Index Organized Tables
Next
From: Robert Haas
Date:
Subject: Re: A thought on Index Organized Tables