| From: | Paul Ramsey <pramsey(at)cleverelephant(dot)ca> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
| Cc: | Binguo Bao <djydewang(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [proposal] de-TOAST'ing using a iterator |
| Date: | 2019-09-25 20:40:36 |
| Message-ID: | 04637661-B21E-4AA8-8BA7-DC9852C7B0AF@cleverelephant.ca |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> On Sep 23, 2019, at 9:45 AM, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> wrote:
>
> Paul Ramsey, do you have opinions to share about this patch? I think
> PostGIS might benefit from it. Thread starts here:
I like the idea a great deal, but actually PostGIS is probably neutral on it: we generally want to retrieve things off the front of our serializations (the metadata header) rather than search through them for things in the middle. So the improvements to Pg12 cover all of our use cases. Haven’t had time to do any performance checks on it yet.
ATB,
P.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2019-09-25 20:45:46 | Re: benchmarking Flex practices |
| Previous Message | Alvaro Herrera | 2019-09-25 20:38:34 | Re: Optimize partial TOAST decompression |