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 <[EMAIL PROTECTED]> ---- http://rp-online.de/ ---- ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
