Re: effective SELECT from child tables - Mailing list pgsql-hackers

From mark@mark.mielke.cc
Subject Re: effective SELECT from child tables
Date
Msg-id 20051002182553.GA13522@mark.mielke.cc
Whole thread Raw
In response to Re: effective SELECT from child tables  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-hackers
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
bindthem...
 
                          http://mark.mielke.cc/



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: External Sort timing debug statements
Next
From: Martijn van Oosterhout
Date:
Subject: Re: effective SELECT from child tables