Re: [HACKERS] fsync method checking

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB SD
Тема Re: [HACKERS] fsync method checking
Дата
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA496208C@m0114.s-mxs.net
обсуждение исходный текст
Список pgsql-performance
> Ideally that path isn't taken very often.  But I'm currently having a
> discussion off-list with a CMU student who seems to be seeing a case
> where it happens a lot.  (She reports that both WALWriteLock and
> WALInsertLock are causes of a lot of process blockages, which seems to
> mean that a lot of the WAL I/O is being done with both held, which would
> have to mean that AdvanceXLInsertBuffer is doing the I/O.
> More when we figure out what's going on exactly...)

I would figure, that this is in a situation where a large transaction
fills one XLInsertBuffer, and a lot of WAL buffers are not yet written.

Andreas

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

Предыдущее
От: Evil Azrael
Дата:
Сообщение: Re: "select max/count(id)" not using index
Следующее
От: Conny Thimren
Дата:
Сообщение: general peformance question