ManticMoo.COM All Articles Jeff's Articles
Jeffrey P. Bigham

Does PostgreSQL Compress Text

Jeffrey P. Bigham

Related Ads

If you're storing a ton of data in a Postgres database, you might, at some point, wonder how efficient PostgreSQL is at compressing your text or whether it's compressing your text at all. The answer is that PostgreSQL does compress your text, although you might get slightly better compression if you do it yourself (probably at a performance hit). Basically, most of us don't need to worry about it because something reasonable is already happening by default.

See this discussion for a bit more.

Jeffrey P. Bigham
ManticMoo.COM All Articles Jeff's Articles