hard20 pts · first answer countsdatabasespostgresqlmvcc
Tables grow though rows are deleted
In PostgreSQL, a busy table keeps growing on disk and queries slow down, though rows are updated, not added. An analytics session has been 'idle in transaction' for two days. How are these linked?
Discussion 0
Join free to post in the discussion.
Related questions
- Building SQL from user inputBackend Developer
- What atomicity guaranteesBackend Developer
- WHERE column = NULL finds nothingBackend Developer
- COUNT(*) versus COUNT(column)Backend Developer
- Column type for pricesBackend Developer
- Storing order times for two countriesBackend Developer
- Students and courses table designBackend Developer
- What a foreign key doesBackend Developer