Page MenuHomeSoftware Heritage
Create Task
Maniphest T1073

Remove temporary table usage for read-only queries
Closed, MigratedEdits Locked
Actions

Description

Read-only queries make use of temporary tables. This means we cannot do them on a physical replica, such as the azure replica, as it's impossible to use temporary tables there.

We need to refactor most of our read-only queries to avoid temporary tables. This should also reduce the churn on the PostgreSQL catalog tables.

Revisions and Commits

rDSTO Storage manager
D340rDSTOa16796047b33 Migrate away from temporary tables for read queries

Related Objects
Search...

Event Timeline

olasd triaged this task as High priority.May 28 2018, 6:46 PM
olasd created this task.
zack moved this task from Restricted Project Column to Restricted Project Column on the Restricted Project board.May 28 2018, 11:09 PM
olasd moved this task from Restricted Project Column to Restricted Project Column on the Restricted Project board.May 31 2018, 5:29 PM
olasd mentioned this in D337: Only hit the database once for directory listings.May 31 2018, 6:42 PM
olasd added a revision: D340: Migrate away from temporary tables for read queries.Jun 4 2018, 8:24 PM
olasd closed this task as Resolved by committing rDSTOa16796047b33: Migrate away from temporary tables for read queries.Jun 5 2018, 1:57 PM
olasd added a commit: rDSTOa16796047b33: Migrate away from temporary tables for read queries.
zack moved this task from Restricted Project Column to Restricted Project Column on the Restricted Project board.Jun 6 2018, 3:15 PM
ardumont mentioned this in T1095: indexer: Remove temporary table usage for read-only queries.Jun 11 2018, 11:01 AM
gitlab-migration changed the task status from Resolved to Migrated.Oct 19 2022, 5:53 PM
gitlab-migration claimed this task.
gitlab-migration added a subscriber: gitlab-migration.

This task has been migrated to GitLab.

About · Developer information · Legal