On Tue, 16 Jun 2015 04:45:52 -0300 "Leonardo M. Ramé" <l.r...@griensu.com> wrote:
> Hi, does anyone know if there's a compression function to let me store > in gzipped/deflate format TEXT or Bytea fields. > > Please correct me if I'm wrong, but I also wonder if this function is > really needed since I've read large objects are stored with TOAST, hence > compression is already there. The TOAST system does do compression, but depending on your expectation, you may be disappointed. The big thing that might let you down is that the TOAST code doesn't run at all unless the tuple is larger than 2K. As a result, you could have fairly large rows of almost 2000 bytes long, that _could_ compress to significantly less than that, but PostgreSQL never tries to compress. Additionally, PostgreSQL stops trying to compress fields once the row size is smaller than 2K, so if you have multiple fields that could benefit from compression, they might not all be compressed. As a result, if you understand your data well, you need to take this into account, as you might see better results if you do your own compression. Unfortunately, I don't know of any in-database function that can be used to compress data; you'd have to write your own or do it at the application level. -- Bill Moran <wmo...@potentialtech.com> -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general