Re: Load distributed checkpoint

Поиск
Список
Период
Сортировка
От Takayuki Tsunakawa
Тема Re: Load distributed checkpoint
Дата
Msg-id 027701c7289b$d9f0fe40$19527c0a@OPERAO
обсуждение исходный текст
Ответ на Re: Load distributed checkpoint  ("Zeugswetter Andreas ADI SD" <ZeugswetterA@spardat.at>)
Список pgsql-hackers
Hello, Inaam-san,
 
> There are four IO schedulers in Linux. Anticipatory, CFQ (default), deadline, and noop. For typical OLTP type loads generally deadline is recommended. If you are constrained on CPU and you have a good controller then its better to use noop.
> Deadline attempts to merge requests by maintaining two red black trees in sector sort order and it also ensures that a request is serviced in given time by using FIFO. I don't expect it to do the magic but was wondering that it may dilute the issue of fsync() elbowing out WAL writes.
> You can look into /sys/block/<device>/queue/scheduler to see which scheduler you are using.
 
Thank you for your information.
I could only find the following files in /sys/block/<device>/queue/:
 
iosched
max_hw_sectors_kb
max_sectors_kb
nr_requests
read_ahead_kb
 
In iosched, the following files exist:
 
quantum (the content is "4")
queued (the content is "8")

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

Предыдущее
От: "Knut P. Lehre"
Дата:
Сообщение: Windows installer and dlls
Следующее
От: "Takayuki Tsunakawa"
Дата:
Сообщение: Re: Load distributed checkpoint