2008/10/26 Martin Gainty <mgainty(at)hotmail(dot)com>:
> Scott-
>
> Straight from Postgres doc
> The zlib compression library will be used by default. If you don't want to
> use it then you must specify the --without-zlib option for configure. Using
> this option disables support for compressed archives in pg_dump and
> pg_restore.
I was thinking more along the lines of the automatic compression of
text types over 4k or so when they are moved out of line and into
toast tables.
The original question was a little vague though wasn't it?