medium10 pts · first answer countsindexing
Index for a huge append-only log
An events table gets 2 crore new rows per day in time order and is queried by time ranges. A B-tree on created_at is 60 GB. What PostgreSQL index type gives a tiny index that still prunes most pages?
Discussion 0
Join free to post in the discussion.
Related questions
- When a B-tree index helpsDatabase Administrator
- Index on a yes/no columnDatabase Administrator
- How InnoDB stores table rowsDatabase Administrator
- What an InnoDB secondary index points toDatabase Administrator
- LIKE with a leading %Database Administrator
- What a hash index supportsDatabase Administrator
- Cost of extra indexes on insertsDatabase Administrator
- EXPLAIN versus EXPLAIN ANALYZEDatabase Administrator