Re: effective SELECT from child tables
От
mark@mark.mielke.cc
Тема
Re: effective SELECT from child tables
Дата
Msg-id
20051002182553.GA13522@mark.mielke.cc
Ответ на
Re: effective SELECT from child tables (Martijn van Oosterhout)
Список
Дерево обсуждения
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 по дате отправления