Daniel Migowski wrote:
A small investigation showed to me that bzip2 compressed sql files take only 60% of the space of gz compressed files. Since bzip2 is fairly common today, could one add an option to pg_dump and pg_restore supporting this compression type in their custom format? Or do the PostgreSQL folks prefer no to do that regarding backwards compatibility?
http://wiki.postgresql.org/wiki/Developer_FAQ#Why_aren.27t_there_more_compression_options_when_dumping_tables.3F now has a first round answer to this topic, one that addresses the things that pop up every time this discussion is raised. There are speed, code quality, code license, and patent issues all making this much harder to change than is obvious at first.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.us