Re: A thought on Index Organized Tables

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: A thought on Index Organized Tables
Дата
Msg-id
27890.1267199249@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
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>
Greg Stark  writes:
> On Fri, Feb 26, 2010 at 4:47 AM, Tom Lane  wrote:
>>> I feel the other one is easy. To store the hint bits inside the ItemId, in
>>> the place of size.
>> 
>> No, we're not going there.

> Well we were already talking about moving the hint bits to someplace
> else to enable CRC checking. My favourite place was the line pointer,
> but you wanted a separate area -- either of which would have these
> problems.

IIRC, what was being talked about was shoehorning some hint bits into
the line pointers by assuming that size and offset are multiples of 4.
I'm not thrilled with having mutable status bits there for reliability
reasons, but it could be done without breaking a lot of existing code.
What I was reacting to above was a suggestion that we could delete the
itempointer size field altogether, which seems unworkable for the
reasons I mentioned.
		regards, tom lane

В списке pgsql-hackers по дате отправления
От: Erik Rijkers
Дата:
От: Tom Lane
Дата:
FAQ