Postgres Pro
Downloads
Home   >   mailing lists

Re: Seeking performance advice and explanation for high I/O on 8.3 - Mailing list pgsql-performance

From Scott Otis
Subject Re: Seeking performance advice and explanation for high I/O on 8.3
Date
Msg-id F406B740738CB44A8BCBEF9734ECF66303296C@albus.intand.com
Whole thread Raw
In response to Seeking performance advice and explanation for high I/O on 8.3  ("Scott Otis" <scott.otis@intand.com>)
Responses Re: Seeking performance advice and explanation for high I/O on 8.3
List pgsql-performance
Tree view
Robert Haas <robertmhaas@gmail.com>:
 
> Do you by any chance have a bazillion databases in this cluster?  Can
> you do these?

> select sum(1) from pg_database;
 
1555

> select pg_relation_size('pg_database');
 
221184

> select sum(pg_column_size(d.*)) from pg_database;
 
That gave me:
 
ERROR:  missing FROM-clause entry for table "d"
LINE 1: select sum(pg_column_size(d.*)) from pg_database;
So I did this:
 
select sum(pg_column_size(d.*)) from pg_database as d;
 
and got:
 
192910
 
Also did this:
 
select sum(pg_database_size(datname)) from pg_database;
 
and got:
 
13329800428 (12.4GB)
 
Scott
 

pgsql-performance by date:

Previous
From: "Scott Otis"
Date:
Subject: Re: Seeking performance advice and explanation for high I/O on 8.3
Next
From: Claus Guttesen
Date:
Subject: Re: Seeking performance advice and explanation for high I/O on 8.3