Re: Rapidly decaying performance repopulating a large table

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: Rapidly decaying performance repopulating a large table
Дата
Msg-id Pine.GSO.4.64.0804230153360.22837@westnet.com
обсуждение исходный текст
Ответ на Re: Rapidly decaying performance repopulating a large table  ("David Wilson" <david.t.wilson@gmail.com>)
Список pgsql-general
On Tue, 22 Apr 2008, David Wilson wrote:

> Is there a way to get the size of a specific index, on that note?

select pg_size_pretty(pg_relation_size('index_name')) works for me.

There's a neat article on other things you can look at like this at
http://andreas.scherbaum.la/blog/archives/282-table-size,-database-size.html

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

В списке pgsql-general по дате отправления:

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Rapidly decaying performance repopulating a large table
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Rapidly decaying performance repopulating a large table