It has been running at least since 2018.
I got that from the tail
=> /sys/kernel/mm/ksm/run <==
0
==> /sys/kernel/mm/transparent_hugepage/defrag <==
[always] madvise never
==> /sys/kernel/mm/transparent_hugepage/enabled <==
always madvise [never]
==> /sys/kernel/mm/transparent_hugepage/khugepaged/defrag <==
[yes] no
==> /proc/sys/vm/zone_reclaim_mode <==
0
On Thu, Jul 21, 2022 at 4:32 PM bruno da silva <brunogi...@gmail.com> wrote:
> Thanks, I will check it out.
>
> On Thu, Jul 21, 2022 at 4:21 PM Justin Pryzby <pry...@telsasoft.com>
> wrote:
>
>> On Thu, Jul 21, 2022 at 03:59:30PM -0400, bruno da silva wrote:
>> > OS/version: CentOS release 6.9 (Final)
>>
>> How are these set ?
>>
>> tail /sys/kernel/mm/ksm/run
>> /sys/kernel/mm/transparent_hugepage/{defrag,enabled,khugepaged/defrag}
>> /proc/sys/vm/zone_reclaim_mode
>>
>> I suspect you may be suffering from issues with transparent huge pages.
>>
>> I suggest to disable KSM and THP, or upgrade to a newer OS.
>>
>> I've written before about these:
>> https://www.postgresql.org/message-id/20170524155855.gh31...@telsasoft.com
>> https://www.postgresql.org/message-id/20190625162338.gf18...@telsasoft.com
>> https://www.postgresql.org/message-id/20170718180152.ge17...@telsasoft.com
>> https://www.postgresql.org/message-id/20191004060300.ga11...@telsasoft.com
>> https://www.postgresql.org/message-id/20200413144254.gs2...@telsasoft.com
>> https://www.postgresql.org/message-id/20220329182453.ga28...@telsasoft.com
>>
>> On Thu, Jul 21, 2022 at 04:01:10PM -0400, bruno da silva wrote:
>> > The issue started a month ago.
>>
>> Ok .. but how long has the DB been running under this environment ?
>>
>> --
>> Justin
>>
>
>
> --
> Bruno da Silva
>
--
Bruno da Silva
