On Fri, Jun 23, 2017 at 6:08 AM, Chapman Flack <c...@anastigmatix.net> wrote: > Well, gzip was doing pretty well; it could get a 16 MB segment file down > to under 27 kB, or less than 14 bytes for each of 2000 pages, when a page > header is what, 20 bytes, it looks like? I'm not sure how much better > I'd expect a (non-custom) compression scheme to do. The real difference > comes between compressing (even well) a large unchanged area, versus being > able to recognize (again with a non-custom tool) that the whole area is > unchanged.
Have you tried as well lz4 for your cases? It performs faster than gzip at minimum compression and compresses less, but I am really wondering if for almost zero pages it performs actually better. -- Michael -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
