senselab/ansible-role-configure-postgresql
3
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity

Add maintenance_work_memory setting? #1

New issue
Closed
opened 2024-06-16 13:45:26 +02:00 by lars · 1 comment
lars commented 2024-06-16 13:45:26 +02:00
Owner
Copy link

It seems to be relevant for vacuum operations (escpecially for exclusive-lock operations like VACUUM FULL) to increase the memory to be used by the maintenance worker.

The postgresql configuration could look like this (/etc/postgresql/15/main/conf.d/sao-local.conf):

# speed up "vacuum" operation with more memory
maintenance_work_mem = 512M

A suitable setting for the ansible could be:

# maintenance memory is relevant for "vacuum" operations
postgresql_maintenance_memory_size: 512M

Currently the role does not create a configuration file for postgresql.
This would require a few new steps here.

(or maybe the setting is not relevant)

It seems to be relevant for `vacuum` operations (escpecially for exclusive-lock operations like `VACUUM FULL`) to increase the memory to be used by the maintenance worker. The postgresql configuration could look like this (`/etc/postgresql/15/main/conf.d/sao-local.conf`): ``` # speed up "vacuum" operation with more memory maintenance_work_mem = 512M ``` A suitable setting for the ansible could be: ``` # maintenance memory is relevant for "vacuum" operations postgresql_maintenance_memory_size: 512M ``` Currently the role does not create a configuration file for postgresql. This would require a few new steps here. (or maybe the setting is not relevant)
phil commented 2024-07-03 20:40:41 +02:00
Owner
Copy link

This role is not intended for PostgreSQL's configuration. We use this role for that purpose.

Have a look at our configuration example.

This role is not intended for PostgreSQL's configuration. We use [this](https://github.com/geerlingguy/ansible-role-postgresql) role for that purpose. Have a look at our [configuration example](https://git.systemausfall.org/systemausfall.org/ansible/src/branch/main/host_vars/database.sao/postgresql.yaml).
phil closed this issue 2024-07-03 20:40:41 +02:00
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
main
No results found.
Labels
Clear labels
No items
No labels
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
2 participants
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: senselab/ansible-role-configure-postgresql#1
No description provided.
Delete branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?