Re: A thought on Index Organized Tables

Поиск
Список
Период
Сортировка
Искать
От
Gokulakannan Somasundaram
Тема
Re: A thought on Index Organized Tables
Дата
Msg-id
9362e74e1002260036m7f0795bfh9bea5839f9187905@mail.gmail.com
Ответ на
Список
Дерево обсуждения
A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: A thought on Index Organized Tables Simon Riggs <simon@2ndQuadrant.com>
Re: A thought on Index Organized Tables "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: A thought on Index Organized Tables Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: A thought on Index Organized Tables Simon Riggs <simon@2ndQuadrant.com>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Simon Riggs <simon@2ndQuadrant.com>
Re: A thought on Index Organized Tables Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: A thought on Index Organized Tables Simon Riggs <simon@2ndQuadrant.com>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Simon Riggs <simon@2ndQuadrant.com>
Re: A thought on Index Organized Tables Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: A thought on Index Organized Tables Robert Haas <robertmhaas@gmail.com>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Robert Haas <robertmhaas@gmail.com>
Re: A thought on Index Organized Tables Karl Schnaitter <karlsch@gmail.com>
Re: A thought on Index Organized Tables Tom Lane <tgl@sss.pgh.pa.us>
Re: A thought on Index Organized Tables Greg Stark <gsstark@mit.edu>
Re: A thought on Index Organized Tables Simon Riggs <simon@2ndQuadrant.com>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Greg Stark <gsstark@mit.edu>
Re: A thought on Index Organized Tables "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: A thought on Index Organized Tables Tom Lane <tgl@sss.pgh.pa.us>
Re: A thought on Index Organized Tables Greg Stark <gsstark@mit.edu>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Tom Lane <tgl@sss.pgh.pa.us>
Re: A thought on Index Organized Tables Greg Stark <gsstark@mit.edu>
Re: A thought on Index Organized Tables Tom Lane <tgl@sss.pgh.pa.us>
Re: A thought on Index Organized Tables Greg Stark <gsstark@mit.edu>
Re: A thought on Index Organized Tables Tom Lane <tgl@sss.pgh.pa.us>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Karl Schnaitter <karlsch@gmail.com>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Karl Schnaitter <karlsch@gmail.com>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Tom Lane <tgl@sss.pgh.pa.us>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Tom Lane <tgl@sss.pgh.pa.us>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Karl Schnaitter <karlsch@gmail.com>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Karl Schnaitter <karlsch@gmail.com>
Re: A thought on Index Organized Tables Tom Lane <tgl@sss.pgh.pa.us>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Tom Lane <tgl@sss.pgh.pa.us>
Re: A thought on Index Organized Tables Greg Stark <gsstark@mit.edu>
Re: A thought on Index Organized Tables Tom Lane <tgl@sss.pgh.pa.us>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Tom Lane <tgl@sss.pgh.pa.us>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Tom Lane <tgl@sss.pgh.pa.us>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Greg Stark <gsstark@mit.edu>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Tom Lane <tgl@sss.pgh.pa.us>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Greg Stark <gsstark@mit.edu>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: A thought on Index Organized Tables Tom Lane <tgl@sss.pgh.pa.us>
Re: A thought on Index Organized Tables "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: A thought on Index Organized Tables Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: A thought on Index Organized Tables Tom Lane <tgl@sss.pgh.pa.us>
Re: A thought on Index Organized Tables Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: A thought on Index Organized Tables Tom Lane <tgl@sss.pgh.pa.us>
Re: A thought on Index Organized Tables Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: A thought on Index Organized Tables Gokulakannan Somasundaram <gokul007@gmail.com>
Re: A thought on Index Organized Tables Andrew Dunstan <andrew@dunslane.net>
Re: A thought on Index Organized Tables Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: A thought on Index Organized Tables Greg Stark <gsstark@mit.edu>
Re: A thought on Index Organized Tables Csaba Nagy <ncslists@googlemail.com>
Re: A thought on Index Organized Tables Alvaro Herrera <alvherre@commandprompt.com>
To be a bit more concrete: the typical sort of failure that you could
get from broken btree operators is failure of transitivity, that is
the comparators report A < B and B < C for some A, B, C, but do not say
that A < C when those two values are compared directly.  I don't see any
convenient way to detect that as a byproduct of normal index operations,
because you wouldn't typically have a reason to make all three
comparisons in close proximity.  Indeed, the searching and sorting
algorithms do their best to avoid making "redundant" comparisons of that
kind.

This is interesting Tom, but i am unable to understand, why it won't affect the current indexes. While insertion it might get inserted in a block and offset, and while searching it might either return no results / show a wrong place. Because ordering is required for searching also right? I definitely feel, i am missing something here.

Gokul.
В списке pgsql-hackers по дате отправления
От: Greg Smith
Дата:
От: Piyush Newe
Дата:
Сообщение: Correcting Error message
FAQ