[YSQL] Investigate using docdb for temporary tables - Githubissues

yugabyte / yugabyte-db

YugabyteDB - the cloud native distributed SQL database for mission-critical applications.

https://www.yugabyte.com

Other

8.9k stars 1.06k forks source link

[YSQL] Investigate using docdb for temporary tables #2175

Open ndeodhar opened 5 years ago

ndeodhar commented 5 years ago

Jira Link: DB-1738 Currently, temporary tables use Postgres storage and transactions instead of YB storage and transactions. Due to this, while enabling any feature (example, procedures, triggers, indexes) etc., we need to do special handling for temp tables. This has also resulted in bugs such as: https://github.com/YugaByte/yugabyte-db/issues/2061 https://github.com/YugaByte/yugabyte-db/issues/1546 https://github.com/YugaByte/yugabyte-db/issues/1469 https://github.com/YugaByte/yugabyte-db/issues/1541 https://github.com/YugaByte/yugabyte-db/issues/1829

We should re-evaluate this approach and investigate impact of using YB storage for temp tables.

FranckPachot commented 1 year ago

Linking an issue with temporary tables in functions: https://github.com/yugabyte/yugabyte-db/issues/19242