| From: | Жарков Роман <r(dot)zharkov(at)postgrespro(dot)ru> |
|---|---|
| To: | "Teodor Sigaev" <teodor(at)sigaev(dot)ru> |
| Cc: | "Michael Paquier" <michael(at)paquier(dot)xyz>, "Aleksander Alekseev" <aleksander(at)timescale(dot)com>, "Pgsql Hackers" <pgsql-hackers(at)postgresql(dot)org>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: type cache cleanup improvements |
| Date: | 2024-03-29 04:49:55 |
| Message-ID: | 1d01a3-66064880-1-7cb74a00@198342865 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> Rest of patches, rebased.
Hello,
I read and tested only the first patch so far. Creation of temp
tables and rollback in your script work 3-4 times faster with
0001-type-cache.patch on my windows laptop.
In the patch I found a copy of the comment "If it's domain over
composite, reset flags...". Can we move the reset flags operation
and its comment into the invalidateCompositeTypeCacheEntry()
function? This simplify the TypeCacheRelCallback() func, but
adds two more IF statements when we need to clean up a cache
entry for a specific relation. (diff attached).
--
Roman Zharkov
| Attachment | Content-Type | Size |
|---|---|---|
| mapRelType-v2.patch | application/octet-stream | 7.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Melanie Plageman | 2024-03-29 05:04:52 | Re: Combine Prune and Freeze records emitted by vacuum |
| Previous Message | Erik Wienhold | 2024-03-29 04:27:17 | Re: PSQL Should \sv & \ev work with materialized views? |