Page MenuHomeSoftware Heritage

Remove temporary table usage for read-only queries
Closed, ResolvedPublic

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.

Event Timeline

olasd created this task.May 28 2018, 6:46 PM
olasd triaged this task as High priority.
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
zack moved this task from Restricted Project Column to Restricted Project Column on the Restricted Project board.Jun 6 2018, 3:15 PM