Re: Direct I/O

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: Direct I/O
Дата
Msg-id 6afb4ce8-0b13-0278-7018-4c9f092148a7@dunslane.net
обсуждение исходный текст
Ответ на Re: Direct I/O  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers


On 2023-04-09 Su 09:14, Andrew Dunstan wrote:


On 2023-04-09 Su 08:39, Thomas Munro wrote:
On Sun, Apr 9, 2023 at 11:25 PM Andrew Dunstan <andrew@dunslane.net> wrote:
Didn't seem to make any difference.
Thanks for testing.  I think it's COW (and I think that implies also
checksums?) that needs to be turned off, at least based on experiments
here.



Googling agrees with you about checksums.  But I'm still wondering if we shouldn't disable COW for the build directory etc. It is suggested at [1]:


Recommend to set nodatacow – turn cow off – for the files that require fast IO and tend to get very big and get alot of random writes: such VMDK (vm disks) files and the like.


I'll give it a whirl.



with COW disabled, I can no longer generate a failure with the test.


cheers


andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: cataloguing NOT NULL constraints
Следующее
От: Noah Misch
Дата:
Сообщение: Re: Doc: Rework contrib appendix -- informative titles, tweaked sentences