Re: Table and Index compression

On 8/6/09 1:03 PM, Greg Stark wrote:
> One possibility is to handle only read-only tables. That would make
> things a *lot* simpler. But it sure would be inconvenient if it's only
> useful on large static tables but requires you to rewrite the whole
> table -- just what you don't want to do with large static tables -- to
> get the benefit.

Well less flexible, I could see combining this with partitioning to
still be useful.  If we could rewrite specific partitions as compressed,
then there's a lot of cumulative data applications which it would benefit.

Not as exciting as being able to compress the whole thing, of course.

-- 
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com