Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-phppgsql-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

pgsql-php by date

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

pgsql-admin by date

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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group