2 ms·
Solving performance by mindlessly adding indexes works great as long as you don't have all too much data and have endless RAM. The index backing the unique con
by marginalia_nu 5y ago
Solving performance by mindlessly adding indexes works great as long as you don't have all too much data and have endless RAM.
The index backing the unique constraint on the URL table for my search engine is around 23 Gb. The entire server has 128 Gb of RAM, for comparison.