Re:Show HN: PostgreSQL Index Advisor
by remus on Sunday April 14, 2024 @02:16PM
(#40033134)
> Are the trade-offs measurable?
Yes, but you need the context about what is the correct tradeoff for your use case. If you've got a service that depends on fast writes then adding latency via extra indices for improved read speed may not be an acceptable trade off. It depends on your application though.
Yes, but you need the context about what is the correct tradeoff for your use case. If you've got a service that depends on fast writes then adding latency via extra indices for improved read speed may not be an acceptable trade off. It depends on your application though.