Re: effective SELECT from child tables

Поиск
Список
Период
Сортировка
Искать
От
mark@mark.mielke.cc
Тема
Re: effective SELECT from child tables
Дата
Msg-id
20051002182553.GA13522@mark.mielke.cc
Ответ на
Список
Дерево обсуждения
effective SELECT from child tables "Ilia Kantor" <ilia@obnovlenie.ru>
Re: effective SELECT from child tables Josh Berkus <josh@agliodbs.com>
Re: effective SELECT from child tables "Ilia Kantor" <ilia@obnovlenie.ru>
Re: effective SELECT from child tables Josh Berkus <josh@agliodbs.com>
Re: effective SELECT from child tables mark@mark.mielke.cc
Re: effective SELECT from child tables Tom Lane <tgl@sss.pgh.pa.us>
Re: effective SELECT from child tables "Ilia Kantor" <ilia@obnovlenie.ru>
Re: effective SELECT from child tables Simon Riggs <simon@2ndquadrant.com>
Re: effective SELECT from child tables "Jim C. Nasby" <jnasby@pervasive.com>
Re: effective SELECT from child tables Simon Riggs <simon@2ndquadrant.com>
Re: effective SELECT from child tables "Jim C. Nasby" <jnasby@pervasive.com>
Re: effective SELECT from child tables Martijn van Oosterhout <kleptog@svana.org>
Re: effective SELECT from child tables "Jim C. Nasby" <jnasby@pervasive.com>
Re: effective SELECT from child tables Andrew Dunstan <andrew@dunslane.net>
Re: effective SELECT from child tables "Ilia Kantor" <ilia@obnovlenie.ru>
Re: effective SELECT from child tables Martijn van Oosterhout <kleptog@svana.org>
Re: effective SELECT from child tables Simon Riggs <simon@2ndquadrant.com>
Re: effective SELECT from child tables mark@mark.mielke.cc
Re: effective SELECT from child tables Martijn van Oosterhout <kleptog@svana.org>
Re: effective SELECT from child tables "Jim C. Nasby" <jnasby@pervasive.com>
Re: effective SELECT from child tables Simon Riggs <simon@2ndquadrant.com>
Re: effective SELECT from child tables Hannu Krosing <hannu@skype.net>
Re: effective SELECT from child tables Greg Stark <gsstark@mit.edu>
Re: effective SELECT from child tables Hannu Krosing <hannu@skype.net>
Re: effective SELECT from child tables Martijn van Oosterhout <kleptog@svana.org>
Re: effective SELECT from child tables Hannu Krosing <hannu@skype.net>
Re: effective SELECT from child tables Martijn van Oosterhout <kleptog@svana.org>
Re: effective SELECT from child tables Greg Stark <gsstark@mit.edu>
Re: effective SELECT from child tables Hannu Krosing <hannu@skype.net>
Re: effective SELECT from child tables Greg Stark <gsstark@mit.edu>
Re: effective SELECT from child tables Tom Lane <tgl@sss.pgh.pa.us>
Re: effective SELECT from child tables Hannu Krosing <hannu@skype.net>
Re: effective SELECT from child tables Greg Stark <gsstark@mit.edu>
Re: effective SELECT from child tables Rod Taylor <pg@rbt.ca>
Re: effective SELECT from child tables Rod Taylor <pg@rbt.ca>
Re: effective SELECT from child tables Greg Stark <gsstark@mit.edu>
Re: effective SELECT from child tables "Jim C. Nasby" <jnasby@pervasive.com>
Re: effective SELECT from child tables Greg Stark <gsstark@mit.edu>
Re: effective SELECT from child tables Greg Stark <gsstark@mit.edu>
Re: effective SELECT from child tables "Jim C. Nasby" <jnasby@pervasive.com>
Re: effective SELECT from child tables Martijn van Oosterhout <kleptog@svana.org>
Re: effective SELECT from child tables "Jim C. Nasby" <jnasby@pervasive.com>
Re: effective SELECT from child tables mark@mark.mielke.cc
Re: effective SELECT from child tables mark@mark.mielke.cc
Re: effective SELECT from child tables "Jim C. Nasby" <jnasby@pervasive.com>
If one defines a restriction such that 'COLUMN = VALUE' for a specific
table, in a theoretical sort of model that completely ignores
implementation difficulty, or changes to the restriction, I think it
would be safe to not store COLUMN in the tuple. If the tuple is
stored, then COLUMN = VALUE, so when fetched, the value will be VALUE.

Back to the real world, this would be difficult to implement without
treating the column special from the point of table creation, and
preventing the restriction from being altered without re-building
the table... :-)

Cheers,
mark

-- 
mark@mielke.cc / markm@ncf.ca / markm@nortel.com     __________________________
.  .  _  ._  . .   .__    .  . ._. .__ .   . . .__  | Neighbourhood Coder
|\/| |_| |_| |/    |_     |\/|  |  |_  |   |/  |_   | 
|  | | | | \ | \   |__ .  |  | .|. |__ |__ | \ |__  | Ottawa, Ontario, Canada
 One ring to rule them all, one ring to find them, one ring to bring them all                      and in the darkness bind them...
                          http://mark.mielke.cc/


В списке pgsql-hackers по дате отправления
От: Simon Riggs
Дата:
От: Martijn van Oosterhout
Дата:
FAQ