PGCon2019 - 3.4
PGCon 2019
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Pankaj Kapoor |
| Schedule | |
|---|---|
| Day | Talks - Day 2 - 2019-05-31 |
| Room | DMS 1110 |
| Start time | 13:00 |
| Duration | 00:45 |
| Info | |
| ID | 1321 |
| Event type | Lecture |
| Track | Hacking |
| Language used for presentation | English |
| Feedback | |
|---|---|
|
Did you attend this event? Give Feedback |
Pluggable table access methods (pluggable storage)
pluggable storage
Pluggable table access methods (pluggable storage)
PostgreSQL supports only single type of table unlike many other RDBMS. In this talk, it will be discussed need for pluggable storage and its benefits and next steps of pluggable storage in future PostgreSQL versions.
Pluggable storages is hot subject in PostgreSQL development. The period of heated debates about whether we need them is over.
Skepticism about pluggable storages, based on concern that they may be source of inconsistent behavior.
It became widely understandable that pluggable storages are needed at least for an alternative MVCC implementation.
And that is one of way-points for pluggable storages interface design.
This talk will cover following subjects:
- overview of pluggable storages interface;
- changes in PostgreSQL core required to implement this interface;
- current and potential implementations of pluggable storages including heap with undo-log and in-memory engines;
- current state of patch-set and prospective of its commit
- further development of interface allowing more possibilities in pluggable storages (columnar, index-organized, LSM and so on).'