From: | Dennis Schwan <dennis(dot)schwan(at)1und1(dot)de> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Load Peaks on Standby/Replication Server using Luks/dmcrypt |
Date: | 2020-01-28 10:02:10 |
Message-ID: | 5566a35a-fbc9-39f4-d033-ed1a13bc82da@1und1.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)schwan(at)1und1(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Игорь Выскорко | 2020-01-28 13:50:07 | Jsonb first level keys statistic |
Previous Message | Willy-Bas Loos | 2020-01-28 09:04:46 | Re: temporary data after diskspace error |