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

index scans, reads, fetches

From: Sam Nelson <samn(at)consistentstate(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: index scans, reads, fetches
Date: 2011-02-22 22:59:28
Message-ID: AANLkTimWkV+6OwpRsYnS836sdBkXba=AFDUROHCr5sM0@mail.gmail.com (view raw or flat)
Thread:
Lists: 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

Next:From: Prabhjot S. SheenaDate: 2011-02-22 23:44:34
Subject: Intallation of postgres 9.0.3 gives an error on already installed postgres 8.4 on the same machine
Previous:From: Kevin GrittnerDate: 2011-02-22 22:51:28
Subject: Re: ssl connection problem

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