>>> On Mon, Nov 5, 2007 at 10:42 AM, in message
<[EMAIL PROTECTED]>, "Campbell,
Lance" <[EMAIL PROTECTED]> wrote:
> How can I [. . .] get rid of some unnecessary indexes
Here's what I periodically run to look for unused indexes:
select relname, indexrelname
from pg_stat_user_indexes
where
PostgreSQL:8.2.4
I am collecting statistics info now on my database. I have used the
following two queries:
select * from pg_stat_all_indexes;
select * from pg_statio_all_indexes;
How can I use the information from these two queries to better optimize
my indexes? Or maybe even get ri
