Joshua D. Drake wrote: > Brian Hurt wrote: > >My apologies if this subject has already been hashed to death, or if > >this is the wrong list, but I was wondering if people had seen this paper: > >http://www.cwi.nl/htbin/ins1/publications?request=intabstract&key=ZuHeNeBo:ICDE:06 > > > > > > > >Basically it describes a compression algorithm for tables of a > >database. The huge advantage of doing this is that it reduced the disk > >traffic by (approximately) a factor of four- at the cost of more CPU > >utilization. > >Any thoughts or comments? > > I don't know if that is the algorithm we use but PostgreSQL will > compress its data within the table.
But only in certain very specific cases. And we compress on a per-attribute basis. Compressing at the page level is pretty much out of the question; but compressing at the tuple level I think is doable. How much benefit that brings is another matter. I think we still have more use for our limited manpower elsewhere. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
