[GENERAL] Trying to deal with a bloated index

I have a postgres application, with customers using version 7.4 and the next version of the product being built on 8.3 (with HOT). We are having problems with two bloated indexes. One index is on a field whose value never changes. The other, which bloats more severely, is on a field whose

Re: [GENERAL] Trying to deal with a bloated index

Jack Orenstein jack.orenst...@hds.com writes: - How well does the CONCURRENTLY option work? The documentation on REINDEX says An index build with the CONCURRENTLY option failed ... I'm not sure if I'm supposed to read this as a comment on the reliability of the CONCURRENTLY option. No,