Implementation of global temporary tables?
От | Pavel Stehule |
---|---|
Тема | Implementation of global temporary tables? |
Дата | |
Msg-id | CAFj8pRC2h6qhHsFbcE7b_7SagiS6o=5J2UvCwCb05Ka1XFv_Ng@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Implementation of global temporary tables?
Re: Implementation of global temporary tables? Re: Implementation of global temporary tables? |
Список | pgsql-hackers |
Hello
Six years ago we did discuss about global temporary tables - persistent schema, ephemeral data.http://postgresql.nabble.com/idea-global-temp-tables-td2007217.html
more global temp tables are little bit comfortable for developers,
Opened questions:
1. Name and conformance with standard of this feature - because we doesn't support modules, a mapping ANSI -> PG should not be trivial
2. Implementation
I see three possible ways how to implement it:
2.a - using on demand created temp tables - most simple solution, but doesn't help with catalogue bloating
2.b - using unlogged tables for holding statistics, relfilenode, and all necessary data
3.c - store ephemeral metadata only in memory without MVCC
Is there still interest about this feature?
Comments, notes?
Comments, notes?
Pavel
В списке pgsql-hackers по дате отправления: