based on the following article: An Introduction to PostgreSQL Performance Tuning and Optimization

• huge pages: Enabling on Linux will give a performance boost to PostgreSQL (VMPeak / HugePageSize = 4310)
• max_connections: optimal number is roughly 4 times the number of CPU cores. The recommended number is the GREATEST(4 x CPU cores, 100). Beyond this number, a connection pooler such as pgbouncer should be used. avoid setting max_connections too high as it will increase the size of various data structures in Postgres which can result in CPU cycles being wasted
• shared_buffers: variable by workload - starting Point: LEAST(RAM/2, 10GB).
• work_mem: ((Total RAM - shared_buffers)/(16 x CPU cores))
• maintenance_work_mem: 1GB good start
• effective_io_concurrency: SSD = 200, HDD = Number of Disks

It is possible to use curl to query the LXD unix.socket directly:

curl --unix-socket /var/lib/lxd/unix.socket http:/1.0/containers | jq .

Example output:

{

• qemu — brew install qemu

• guestfish — https://hub.docker.com/r/curator/guestfish/

1. Backup VM

Source: https://opensource.com/business/16/2/top-6-open-source-crm-tools-2016 + community contributions

EspoCRM `github.com/espocrm/espocrm`_ PHP https://www.espocrm.com

UPDATE 2023-01-22 21:34:33

This guide was last tested on an Intel MacBook 2017. Since then it's unmaintained and won't be updated (I quit the game and bought a life-time crossover licence).

This has been forked from https://gist.github.com/Alex4386/4cce275760367e9f5e90e2553d655309

For the latest discussion, see the comments there.

WAY MORE UP-TO-DATE GIST (and includes some setup stuff that I forgot to document): https://gist.github.com/sarimarton/471e9ff8046cc746f6ecb8340f942647
Current Development for Building Libre-version of CrossOver: https://github.com/GabLeRoux/macos-crossover-cloud-build.
For Latest Discussions: https://github.com/GabLeRoux/macos-crossover-cloud-build/issues.

This version of gist is outdated since it was written while I was compiling CrossOver v19. and seems to be there are some breaking changes in v19.1+ and 20. Also, I think I missed some required libraries/stub files that was required in build (that I previously installed beforehand). Oops.