Yep, small row counts. Thanks, Greg!
From: Greg Williamson [mailto:gwilliamso...@yahoo.com]
Sent: Monday, 6 December 2010 5:34 PM
To: Samuel Stearns; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] pg_* Tables
Samuel Stearns wrote:
Howdy,
Environment:
Solaris 10
Postgres 8.3.3
I’m
Howdy,
Environment:
Solaris 10
Postgres 8.3.3
I'm getting high sequential scans for some pg_* tables:
database=# select relname, sum(seq_scan) as seq_scan,sum(seq_tup_read) as
seq_tup_read,sum(idx_scan) as idx_scan, sum(idx_tup_fetch) as idx_tup_fetch,
sum(n_tup_ins) as n_tup_ins,
Samuel Stearns wrote:
Howdy,
Environment:
Solaris 10
Postgres 8.3.3
I’m getting high sequential scans for some pg_* tables:
database=# select relname, sum(seq_scan) as seq_scan,sum(seq_tup_read)
as seq_tup_read,sum(idx_scan) as idx_scan, sum(idx_tup_fetch) as