Re: How to analyse the indexes in postgres?

From: Charley Tiggs <lists(at)tiggs(dot)net>
To: Karthikeyan Sundaram <skarthi98(at)hotmail(dot)com>
Cc: pgsql-php(at)postgresql(dot)org
Subject: Re: How to analyse the indexes in postgres?
Date: 2007-02-18 12:59:37
Message-ID: 45D84DB9.1050202@tiggs.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-php pgsql-sql

What version of Postgres are you using?

Charley

Karthikeyan Sundaram wrote:
> 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 6: explain analyze is your friend
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message pedro noticioso 2007-02-18 13:36:52 Re: WAL files backup
Previous Message Thomas Kellerer 2007-02-18 08:21:03 Re: How to analyse the indexes in postgres?

Browse pgsql-php by date

  From Date Subject
Next Message enzo venegas palacios 2007-02-19 21:35:45 update php 4.3 to 5.2
Previous Message Thomas Kellerer 2007-02-18 08:21:03 Re: How to analyse the indexes in postgres?

Browse pgsql-sql by date

  From Date Subject
Next Message S.F. Lee 2007-02-18 13:58:15 unsubscribe
Previous Message Thomas Kellerer 2007-02-18 08:21:03 Re: How to analyse the indexes in postgres?