Index degradation
Alex Balashov <[email protected]> Thu, 7 Nov 2019 14:33:35 -0500
| Newsgroups | gmane.comp.db.postgresql.admin |
|---|---|
| Organization | Evariste Systems |
| Message-ID | <[email protected]> |
Over a period of some years, particularly in tables whose contents periodically get swapped out entirely (i.e. lots of dead rows), indexes slowly degrade, pushing query latency up. Is there a way to detect this condition short of just monitoring statement latency, so as to know when to REINDEX / build new indexes? -- Alex Balashov | Principal | Evariste Systems LLC Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free) Web: http://www.evaristesys.com/, http://www.csrpswitch.com/