| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | Justin Pryzby <pryzby(at)telsasoft(dot)com>, wenjing <wenjing(at)gmail(dot)com>, Andrew Bille <andrewbille(at)gmail(dot)com>, Tony Zhu <Tony(dot)zhu(at)ww-it(dot)cn>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: [Proposal] Global temporary tables |
| Date: | 2022-03-03 01:35:02 |
| Message-ID: | CAFj8pRD0hH1E_dDyM=yYmbwCGdCiLydsda1vjn0MdwN7mOZACA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi
> I think you'd basically have to come up with a generic design for
> partitioning
> catalog tables into local / non-local storage, without needing explicit
> code
> for each catalog. That could also be used to store the default catalog
> contents separately from user defined ones (e.g. pg_proc is pretty large).
>
There is still a risk of bloating in local storage, but, mainly, you
probably have to modify a lot of lines because the system cache doesn't
support partitioning.
Regards
Pavel
>
> Greetings,
>
> Andres Freund
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2022-03-03 02:16:00 | Re: shared-memory based stats collector |
| Previous Message | Michael Paquier | 2022-03-03 01:27:10 | Re: Add CHECKPOINT_REQUESTED flag to the log message in LogCheckpointStart() |