| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | Pavel Golub <pavel(at)gf(dot)microolap(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [HACKERS] proposal: schema variables |
| Date: | 2018-02-07 06:34:44 |
| Message-ID: | CAFj8pRCTsxzsxX1cWgX3cjqsSZb=gqOMd3-2FdbGz5a2+shGMg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
Hi
updated patch with your changes in documentation and pg_dump (initial)
support
Main issue of this patch is storage. We can reuse local buffers used for
temp tables. But it does allocation by 8KB and it creates temp files for
every object. That is too big overhead. Storing just in session memory is
too simple - then there should be lot of new code used, when variable will
be dropped.
I have ideas how to allow work with mix of scalar and composite types - so
it will be next step of this prototype.
Regards
Pavel
>
| Attachment | Content-Type | Size |
|---|---|---|
| schema-variables-poc-180207-01-diff | application/octet-stream | 131.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2018-02-07 06:54:58 | Re: Why does load_external_function() return PGFunction? |
| Previous Message | Tom Lane | 2018-02-07 05:28:04 | Re: Add RANGE with values and exclusions clauses to the Window Functions |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alex Ignatov | 2018-02-07 17:11:57 | RE: pg_xlog unbounded growth |
| Previous Message | Justin Pryzby | 2018-02-07 05:42:27 | Re: effective_io_concurrency on EBS/gp2 |