How to analyse the indexes in postgres?

From: "Karthikeyan Sundaram" <skarthi98(at)hotmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org, pgsql-php(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: How to analyse the indexes in postgres?
Date: 2007-02-18 08:15:01
Message-ID: BAY131-F3813A5AFB925F7E296E072B08B0@phx.gbl
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-php pgsql-sql

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Thomas Kellerer 2007-02-18 08:21:03 Re: How to analyse the indexes in postgres?
Previous Message Andy Shellam (Mailing Lists) 2007-02-17 17:45:51 Re: 8.2 Admin Pack broken?

Browse pgsql-php by date

  From Date Subject
Next Message Thomas Kellerer 2007-02-18 08:21:03 Re: How to analyse the indexes in postgres?
Previous Message Mihail Mihailov 2007-02-12 06:58:49 Re: phpinfo(): postgresql versions' mismatch

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas Kellerer 2007-02-18 08:21:03 Re: How to analyse the indexes in postgres?
Previous Message Bruce Momjian 2007-02-18 01:47:57 Re: Odd PL/PgSQL Error -- relation "X" does not exist when using index expression