[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Load Peaks on Standby/Replication Server using Luks/dmcrypt
From:       Dennis Schwan <dennis.schwan () 1und1 ! de>
Date:       2020-01-28 10:02:10
Message-ID: 5566a35a-fbc9-39f4-d033-ed1a13bc82da () 1und1 ! de
[Download RAW message or body]

Hi,

we are using luks/dmycrypt to encrypt our pgdata volumes.
On some standby/replication machines we see load peaks up to 15x of the
primary server.
If we remove the dmcrypt/luks and run it on a non-encrypted device this
does not happen.

We have tried to analyze this but could not find where the load comes from.
Using atop, pg_top we do not see any waits, not on cpu and not on I/O,
just the higher load.

We see this on KVM hosts and also on Hardware (HDD, SSD, RAID/Non-RAID)
and also tried to set different powerprofiles in the BIOS.

Do you have any idea here? I am happy to get any information you need to
analyze this problem.

Thanks,
Dennis

-- 
Dennis Schwan

DBA
Database Services

1&1 De-Mail GmbH | Brauerstraße 50 | 76135 Karlsruhe | Germany
Phone: +49 721 91374-8738
E-Mail: dennis.schwan@1und1.de | Web: www.1und1.de

Hauptsitz Montabaur, Amtsgericht Montabaur, HRB 23266

Geschäftsführer: Alexander Charles, Thomas Ludwig, Jan Oetjen, Sascha Vollmer

Member of United Internet

Diese E-Mail kann vertrauliche und/oder gesetzlich geschützte Informationen \
enthalten. Wenn Sie nicht der bestimmungsgemäße Adressat sind oder diese E-Mail \
irrtümlich erhalten haben, unterrichten Sie bitte den Absender und vernichten Sie \
diese E-Mail. Anderen als dem bestimmungsgemäßen Adressaten ist untersagt, diese \
E-Mail zu speichern, weiterzuleiten oder ihren Inhalt auf welche Weise auch immer zu \
verwenden.

This e-mail may contain confidential and/or privileged information. If you are not \
the intended recipient of this e-mail, you are hereby notified that saving, \
distribution or use of the content of this e-mail in any way is prohibited. If you \
have received this e-mail in error, please notify the sender and delete the e-mail.


[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic