How much can LVM slow down PostgreSQL?

V

Vladimir2019-04-19 17:46:20

linux

Vladimir, 2019-04-19 17:46:20

Good afternoon. The task was set to deploy a database server on which the performance of the DBMS will be extremely important, so now we are analyzing all possible problems.
There is a suspicion about LVM, which we use as a method of isolating the database at the filesystem level. (if there are a large number of databases on the server, so that one does not kill free space with others during a sharp increase.).
Can LVM greatly affect the performance of the DBMS on the part of the disk subsystem?
And if so, how much?
to clarify, all LVMs will live on top of RAID.

Reply

Answer the question

In order to leave comments, you need to log in

4 answer(s)

R

Ronald McDonald, 2019-04-19
@idskill

LVM does not give strong drawdowns, bet and don't worry.

F

Fixid, 2019-04-19
@Fixid

With typical use of LVM, there are no drawdowns as such. Do read/write tests on your server with/without LVM

R

rPman, 2019-04-19
@rPman

LVM has strong drawdowns in write speed when using snapshots, each new one reduces the speed by almost half.

S

Saboteur, 2019-04-19
@saboteur_kiev

LVM was created for this, so that you can manage free space online.
By itself, LVN does not give a special load, but it all depends on what you will configure with it.