Shaul Dar wrote: > Hi, > > I have several long text fields in my DB that I would love to compress > (descriptions, URLs etc). Can you tell me what options exists in PG > (+pointers please), typical effect on space and run time? variable length text fields .. e.g TEXT will automatically be stored in a TOAST table and compressed. Search the manual for toast. -- Jesper -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance