Postgres Pro
Downloads
Home   >   mailing lists

Sv: PostgreSQL configuration in a VM - Mailing list pgsql-general

From Andreas Joseph Krogh
Subject Sv: PostgreSQL configuration in a VM
Date
Msg-id VisenaEmail.24.3f634cb33cab66f7.1865ec3ad3d@visena.app.internal.visena.net
Whole thread Raw
In response to PostgreSQL configuration in a VM  (Sebastien Flaesch <sebastien.flaesch@4js.com>)
List pgsql-general
Tree view
På fredag 17. februar 2023 kl. 09:13:10, skrev Sebastien Flaesch <sebastien.flaesch@4js.com>:
Hi!

 
I was wondering if the is any specific configuration setting that should be used with PostgreSQL, when running in a VM...

 
Is there anything obvious that must be set, to get best performances with such a config?

 
Sorry for this general question...

In my experience the most important parameter when running in a VM is random_page_cost, and for that to be set to a sane value you need to know the characteristics of the disk available to your VM. In other words, disk IO is what you should be worried about as VMs are pretty good at scaling CPU-wise.

 

--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 
Attachment

pgsql-general by date:

Previous
From: Sebastien Flaesch
Date:
Subject: PostgreSQL configuration in a VM
Next
From: cen
Date:
Subject: Re: Postgres undeterministically uses a bad plan, how to convince it otherwise?