Hi,
On Monday 02 April 2007 10:12, Denis Lishtovny wrote:
| I have a lot of tables and indexes in database. I must to determine which
| indexes are not using or using seldon in databese . I enabled all posible
| statistics in config but a can`t uderstand how to do this.
| Thanks.
Try "select * from pg_stat_user_indexes;" - that should give you a good start
to look at.
| p.s for example i need this to reduce database size for increase backup and
| restore speed.
Deleting indexes won't reduce backup size noticeably (but has impact on
restore speed), if you use pg_dump for backup.
Ciao,
Thomas
--
Thomas Pundt <thomas.pundt@rp-online.de> ---- http://rp-online.de/ ----