Re: RFC: Restructuring pg_aggregate

> Actually, what we need to do to reclaim space is to enable table
> recreation without the column, now that we have relfilenode for file
> renaming.  It isn't hard to do, but no one has focused on it.  I want to
> focus on it, but have not had the time, obviously, and would be very
> excited to assist someone else.

I'm happy to help - depends if it's within my skill level or not tho.  Most
of the time the problem I have is finding where to make the changes, not
actually making the changes themselves.  So, count me in.

> Hiroshi's fine idea of marking certain columns as unused would not have
> reclaimed the missing space, just as my idea of physical/logical column
> distinction would not reclaim the space either.  Again, my
> physical/logical idea is more for fixing other problems and
> optimization, not DROP COLUMN.

Question: Is it _possible_ to reclaim the space during a VACUUM FULL?  I do
not know enough about the file format to know this.  What happens if the
VACUUM is stopped halfway thru reclaiming a column in a table?

Bruce: WRT modifying libpq to do the translation - won't this cause probs
for JDBC and ODBC people?

Chris