| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Junwang Zhao <zhjwpku(at)gmail(dot)com> |
| Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Sean Flaherty <sflaherty(at)grndwork(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Increased storage size of jsonb in pg15 |
| Date: | 2023-12-29 14:22:59 |
| Message-ID: | 3049374.1703859779@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Junwang Zhao <zhjwpku(at)gmail(dot)com> writes:
> On Fri, Dec 29, 2023 at 4:47 AM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
>> For what purpose? You are seeing differences in compression strategies
>> between lz4 and pglz. The 'fix' would be to go back to pglz.
> Agreed, lz4 is known for its high compression speed, but lower
> compression ratio, this is the trade off one should bear in mind.
I don't know if we can make any blanket statements like that, but
if we can, shouldn't there be some advice in the manual? AFAICS,
right now there's exactly zip about why you should choose one over
the other.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sean Flaherty | 2023-12-29 15:21:13 | Re: Increased storage size of jsonb in pg15 |
| Previous Message | ankit.singh | 2023-12-29 14:02:52 | Need help |