> > >> > >Some time ago I changed the pg_stat_temp directory from > /var/lib/pgsq/whatever to /tmp > Have you checked the postgres log to see if there are any errors about it > not being able to write to the pg_stat_temp dir? > > Yep.... no errors =\
- [GENERAL] Unused indexes - PostgreSQL 9.2 Lucas Possamai
- Re: [GENERAL] Unused indexes - PostgreSQL 9.2 Melvin Davidson
- Re: [GENERAL] Unused indexes - PostgreSQL 9.2 Lucas Possamai
- Re: [GENERAL] Unused indexes - PostgreSQL 9... Lucas Possamai
- Re: [GENERAL] Unused indexes - PostgreSQL 9... Melvin Davidson
- Re: [GENERAL] Unused indexes - PostgreS... Lucas Possamai
- Re: [GENERAL] Unused indexes - Pos... Melvin Davidson
- Re: [GENERAL] Unused indexes -... Lucas Possamai
- Re: [GENERAL] Unused index... Melvin Davidson
- Re: [GENERAL] Unused index... Lucas Possamai
- Re: [GENERAL] Unused index... Melvin Davidson
- Re: [GENERAL] Unused index... Lucas Possamai
- Re: [GENERAL] Unused index... Lucas Possamai
- Re: [GENERAL] Unused index... Jeff Janes
- Re: [GENERAL] Unused index... Lucas Possamai
- Re: [GENERAL] Unused index... David G. Johnston
- Re: [GENERAL] Unused index... Melvin Davidson