2009/11/1 Shaul Dar <shauldar@xxxxxxxxx>: > 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? Hello You can do nothing. PostgreSQL compresses data automatically http://www.postgresql.org/docs/8.4/interactive/storage-toast.html Regards Pavel Stehule > > Thanks, > > -- Shaul > -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
