| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Michael Paquier <michael(at)paquier(dot)xyz> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Move pg_attribute.attcompression to earlier in struct for reduced size? |
| Date: | 2021-06-03 16:04:48 |
| Message-ID: | 202106031604.osw7f4udlk2e@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2021-Jun-02, Michael Paquier wrote:
> After 12 runs of VACUUM FULL on my laptop, I have removed the two
> highest and the two lowest to remove some noise, and did an average of
> the rest:
> - HEAD, 100 text columns: 5720ms
> - REL_13_STABLE, 100 text columns: 4308ms
> - HEAD, 200 text columns: 10020ms
> - REL_13_STABLE, 200 text columns: 8319ms
>
> So yes, that looks much visible to me, and an argument in favor of the
> removal of the forced recompression on HEAD when rewriting tuples.
Just to be clear -- that's the time to vacuum the table without changing
the compression algorithm, right? So the overhead is just the check for
whether the recompression is needed, not the recompression itself?
If the check for recompression is this expensive, then yeah I agree that
we should take it out. If recompression is actually occurring, then I
don't think this is a good test :-)
--
Álvaro Herrera Valdivia, Chile
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Dilger | 2021-06-03 16:30:42 | Re: security_definer_search_path GUC |
| Previous Message | Pavel Stehule | 2021-06-03 16:03:09 | Re: security_definer_search_path GUC |