Re: What needs to be done for real Partitioning?

On P, 2005-03-20 at 00:52 +0100, PFC wrote:
> > tableoid would accomplish that already, assuming that the "partitioned
> > table" is effectively a view on separate physical tables.
> >
> > 			regards, tom lane
> 
> 	Very good.
> 
> 	Also note the possibility to mark a partition READ ONLY. Or even a table.
> 	It does not seem very useful but just think that for instance the "1999",  
> "2000" ... "2004" partitions of a big archive probably never change.  
> READLONY means we're sure they never change, thus no need to backup them  
> every time. Keeping the example of some DB arranged by years / current  
> year / current month, Just backup the "current month" part every day and  
> the "current year" every month when you switch partitions.
> 	This could be achieved also by storing the time of last modification of a  
> table somewhere.

Would we still need regular VACUUMing of read-only table to avoid 
OID-wraparound ?

-- 
Hannu Krosing <hannu@tm.ee>