Re: database not using indexes

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-admin(at)postgresql(dot)org>, "Silvio Brandani" <silvio(dot)brandani(at)tech(dot)sdb(dot)it>
Subject: Re: database not using indexes
Date: 2011-11-09 15:48:39
Message-ID: 4EBA4C770200002500042BE2@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Silvio Brandani <silvio(dot)brandani(at)tech(dot)sdb(dot)it> wrote:
> Our database seems not using index anymore, please help with,
> is a production database.
>
> is there a script to check missing index on foreign key ??

You haven't provided enough information to allow anyone to help.

http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

-Kevin

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ruslan A. Bondar 2011-11-09 15:53:50 Re: How to deal with corrupted database?
Previous Message Steve Crawford 2011-11-09 15:29:01 Re: setting timezone