index scans, reads, fetches - Mailing list pgsql-admin

From Sam Nelson
Subject index scans, reads, fetches
Date
Msg-id AANLkTimWkV+6OwpRsYnS836sdBkXba=AFDUROHCr5sM0@mail.gmail.com
Whole thread Raw
List pgsql-admin
Hi list,

We're pulling a number of metrics for a client to help tune their database, and we had some questions about the stats coming from pg_stat_user_indexes.  Namely, what do we want the growth (when looking at interval values) of idx_scan, idx_tup_read, and idx_tup_fetch to look like and how do we tune them?
--- 
===========================
Samuel Nelson
Consistent State
www.consistentstate.com
303-955-0509
===========================

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: ssl connection problem
Next
From: "Prabhjot S. Sheena"
Date:
Subject: Intallation of postgres 9.0.3 gives an error on already installed postgres 8.4 on the same machine