Re: checkpointer continuous flushing - V18

Поиск
Список
Период
Сортировка
От Fabien COELHO
Тема Re: checkpointer continuous flushing - V18
Дата
Msg-id alpine.DEB.2.10.1603110807430.20663@sto
обсуждение исходный текст
Ответ на Re: checkpointer continuous flushing - V18  (Andres Freund <andres@anarazel.de>)
Ответы Re: checkpointer continuous flushing - V18  (Peter Geoghegan <pg@heroku.com>)
Список pgsql-hackers
>> As you wish. I thought that understanding the underlying performance model
>> with sequential writes written in chunks is important for the admin, and as
>> this guc would have an impact on performance it should be hinted about,
>> including the limits of its effect where large bases will converge to random
>> io performance. But maybe that is not the right place.
>
> I do agree that that's something interesting to document somewhere. But
> I don't think any of the current places in the documentation are a good
> fit, and it's a topic much more general than the feature we're debating
> here.  I'm not volunteering, but a good discussion of storage and the
> interactions with postgres surely would be a significant improvement to
> the postgres docs.

I can only concur!

The "Performance Tips" chapter (II.14) is more user/query oriented. The 
"Server Administration" bool (III) does not discuss this much.

There is a wiki about performance tuning, but it is not integrated into 
the documentation. It could be a first documentation source.

Also the README in some development directories are very interesting, 
although they contains too much details about the implementation.

There has been a lot of presentations over the years, and blog posts.

-- 
Fabien.



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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: RFC: replace pg_stat_activity.waiting with something more descriptive
Следующее
От: Fabien COELHO
Дата:
Сообщение: Re: checkpointer continuous flushing