On Mon, Apr 13, 2020 at 9:58 AM Justin Pryzby wrote:
> On Mon, Apr 13, 2020 at 09:46:22AM -0500, Don Seiler wrote:
> > ==> /sys/kernel/mm/ksm/run <==
> > 0
>
> Was it off to begin with ?
> If not, you can set it to "2" to "unshare" pages.
>
Yes we haven't changed this. It was already set to 0.
https://www.cybertec-postgresql.com/
With Warm Regards,
Amol P. Tarte
Project Manager,
Rajdeep InfoTechno Pvt. Ltd.
Visit us at http://it.rajdeepgroup.com
On Tue, Apr 7, 2020, 5:21 PM daya airody wrote:
> hi folks,
>
> we are looking for a PostgreSQL DBA to help us in tuning our database.
>
>
On Mon, Apr 13, 2020 at 09:46:22AM -0500, Don Seiler wrote:
> ==> /sys/kernel/mm/ksm/run <==
> 0
Was it off to begin with ?
If not, you can set it to "2" to "unshare" pages.
> ==> /sys/kernel/mm/transparent_hugepage/khugepaged/defrag <==
> 1
So I'd suggest trying with this disabled.
I don't kno
On Mon, Apr 13, 2020 at 9:42 AM Justin Pryzby wrote:
>
> tail /sys/kernel/mm/ksm/run
> /sys/kernel/mm/transparent_hugepage/khugepaged/defrag
> /sys/kernel/mm/transparent_hugepage/enabled
> /sys/kernel/mm/transparent_hugepage/defrag
>
# tail /sys/kernel/mm/ksm/run
/sys/kernel/mm/transparent_hugep
On Mon, Apr 13, 2020 at 09:34:23AM -0500, Don Seiler wrote:
> Good morning,
>
> Ubuntu 16.04.6 LTS
> PostgreSQL 9.6.5
>
> On one of our database servers, we're regularly seeing kswapd at the top of
> "top" output, regularly using over 50 %CPU. We should have well over 80GB
> of available memory a
Good morning,
Ubuntu 16.04.6 LTS
PostgreSQL 9.6.5
On one of our database servers, we're regularly seeing kswapd at the top of
"top" output, regularly using over 50 %CPU. We should have well over 80GB
of available memory according to "free -m".
# free -m
totalusedfre
