3 ms·
In other SQL databases an 'in memory' table could be a candidate. It looks like Postgres only has session specific temporary tables, but does have an UNLOGGED
by mjevans 4y ago
In other SQL databases an 'in memory' table could be a candidate. It looks like Postgres only has session specific temporary tables, but does have an UNLOGGED https://www.postgresql.org/docs/13/sql-createtable.html https://www.postgresql.org/docs/13/sql-createtable.html table type which has desirable properties for temporary data that must be shared.
- cryptonector 4y agoPG really needs GLOBAL TEMP tables...
- mjevans 4y agoThe properties of the UNLOGGED table suggest it fills this niche already.
- cryptonector 4y agoIt's not the same. You can emulate GLOBAL TEMP tables with UNLOGGED, but native GLOBAL TEMP would be better.
- eshnil 4y agoThere's an extension for this: https://github.com/darold/pgtt https://github.com/darold/pgtt