Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system
Дата
Msg-id 5616.1360165250@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system
Список pgsql-hackers
Pavel Stehule <pavel.stehule@gmail.com> writes:
>> Nice. Another interesting numbers would be device utilization, average
>> I/O speed and required space (which should be ~2x the pgstat.stat size
>> without the patch).

> this point is important - with large warehouse with lot of databases
> and tables you have move stat file to some ramdisc - without it you
> lost lot of IO capacity - and it is very important if you need only
> half sized ramdisc

[ blink... ]  I confess I'd not been paying close attention to this
thread, but if that's true I'd say the patch is DOA.  Why should we
accept 2x bloat in the already-far-too-large stats file?  I thought
the idea was just to split up the existing data into multiple files.
        regards, tom lane



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

Предыдущее
От: Phil Sorber
Дата:
Сообщение: Re: [PATCH] pg_isready (was: [WIP] pg_ping utility)
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system