Re: Seeking performance advice and explanation for high I/O on 8.3

Поиск
Список
Период
Сортировка
От Scott Otis
Тема Re: Seeking performance advice and explanation for high I/O on 8.3
Дата
Msg-id F406B740738CB44A8BCBEF9734ECF66303296C@albus.intand.com
обсуждение исходный текст
Ответ на Seeking performance advice and explanation for high I/O on 8.3  ("Scott Otis" <scott.otis@intand.com>)
Ответы Re: Seeking performance advice and explanation for high I/O on 8.3  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-performance
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: "Scott Otis"
Дата:
Сообщение: Re: Seeking performance advice and explanation for high I/O on 8.3
Следующее
От: Claus Guttesen
Дата:
Сообщение: Re: Seeking performance advice and explanation for high I/O on 8.3