[ADMIN] How to analyse the indexes in postgres?

2007-02-18 Thread Karthikeyan Sundaram 

Hi,

   I am new to postgres.   I need some kind of template script or advise on 
how to analyse the indexes.  In our database, we do delete, insert, update 
tons of rows.


Regards
skarthi

_
Refi Now: Rates near 39yr lows!  $430,000 Mortgage for $1,399/mo - Calculate 
new payment 
http://www.lowermybills.com/lre/index.jsp?sourceid=lmb-9632-17727moid=7581



---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

   http://www.postgresql.org/about/donate

Re: [ADMIN] How to analyse the indexes in postgres?

2007-02-18 Thread Thomas Kellerer 

Karthikeyan Sundaram wrote on 18.02.2007 09:15:

Hi,

   I am new to postgres.   I need some kind of template script or advise 
on how to analyse the indexes.  In our database, we do delete, insert, 
update tons of rows.



http://www.postgresql.org/docs/8.2/interactive/routine-reindex.html


---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings