[SQL] How to analyse the indexes in postgres?

[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-17727&moid=7581



---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match

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

[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 9: In versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match

[SQL] unsubscribe

[S.F. Lee]

 unsubscribe 



 

We won't tell. Get more on shows you hate to love 
(and love to hate): Yahoo! TV's Guilty Pleasures list.
http://tv.yahoo.com/collections/265 

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly