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

From [email protected]
Subject Re: effective SELECT from child tables
Date
Msg-id [email protected]
Whole thread Raw
In response to Re: effective SELECT from child tables  (Martijn van Oosterhout <[email protected]>)
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

-- 
[email protected] / [email protected] / [email protected]     __________________________
.  .  _  ._  . .   .__    .  . ._. .__ .   . . .__  | 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