Re: Thousands of tables versus on table?

Поиск
Список
Период
Сортировка
От PFC
Тема Re: Thousands of tables versus on table?
Дата
Msg-id op.tteytsyycigqcu@apollo13
обсуждение исходный текст
Ответ на Re: Thousands of tables versus on table?  (Thomas Andrews <tandrews@soliantconsulting.com>)
Список pgsql-performance

> can tell you our vacuum every night is taking 2 hours and that disk IO is
> the real killer - the CPU rarely gets higher than 20% or so.

    How many gigabytes of stuff do you have in this database ?
    ( du -sh on the *right* directory will suffice, don't include the logs
etc, aim for data/base/oid)


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

Предыдущее
От: Thomas Andrews
Дата:
Сообщение: Re: Thousands of tables versus on table?
Следующее
От: Gregory Stark
Дата:
Сообщение: Re: Thousands of tables versus on table?