Re: [GENERAL] Index utilization

2009-08-14 Thread Emanuel Calvo Franco
2009/8/13 : > I am working on cleaning up a bloated database.  I have been reindexing etc. >  There appear to be a good number of never to almost never used indexes.  I > am looking in pg_stat_user_indexes which yields some questions. > > Assuming that the reset stats on server is not turned on ho

[GENERAL] Index utilization

2009-08-13 Thread kbarnard
I am working on cleaning up a bloated database. I have been reindexing etc. There appear to be a good number of never to almost never used indexes. I am looking in pg_stat_user_indexes which yields some questions. Assuming that the reset stats on server is not turned on how old are sta