Re: Database size 1T but unclear why

Поиск
Список
Период
Сортировка
От Justin Pryzby
Тема Re: Database size 1T but unclear why
Дата
Msg-id 20181211185531.GN21379@telsasoft.com
обсуждение исходный текст
Ответ на Re: Database size 1T but unclear why  (Justin Pryzby <pryzby@telsasoft.com>)
Список pgsql-performance
On Sun, Dec 09, 2018 at 10:01:08AM -0600, Justin Pryzby wrote:
> On Sun, Dec 09, 2018 at 05:18:55PM +0200, Mariel Cherkassky wrote:
> > I'm trying to understand why my database consume so much space. I checked
> > the space it consume on disk :

To find single relations which are using more than 100GB,
you could also run:
|find ..../base/17312 -name '*.[0-9]??'

(technically that should be a regex and not a shell glob but seems to work well
enough).

Justin


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: database crash during pgbench run
Следующее
От: Mariel Cherkassky
Дата:
Сообщение: pgbench results arent accurate