Does PostgreSQL Compress Text

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.