Contributors mailing list archives


Postgres Optimisation

- 19/11/2015 04:37:47

is anyone interested in an open discussion about PSQL optimisation?

Knowledge about PostgreSQL Configuration and Deployment is mostly privately held or simply very scars in the ecosystem. Many of us go probably with the defaults in their daily operations. This however is probably perceived as an uncomfortable black box and one would wish to have more knowledge dispersal in the odoo world to raise the overall deployment quality and establish best practices.

Here is an invitation to join this ad-hoc initiative to do something about this and gather, collect and consolidate the available odoo-specific knowledge. I chose and suggest the following approach:

The 212 config options of postgres9.4 are clustered into 34 (sub)categories, which I copied here for convenience. A comprehensive list of options you can find here:

If you A) know something about any of those categories, please consider replying to this email with a odoo-specific short description, like so:
"category X can be used to do Y. It is noteworthy altering some default values in the context of odoo deployment because Z"


If you have B) some odoo-contextualized knowledge about a specific parameter (of the 212, see linked spreadsheet) please feel free to comment in the sheet iteself.

Throughout gathering phase I would consolidate Knowledge in the excel sheet and once, ideally, gathered sufficient Input, I would then write up a shared authorship blog post about the topic. 

Some hints and general odoo optimizaiton stuff can be found here:
PostgreSQL guides:

Best Regards and thanks for your interest


Version and Platform Compatibility / Previous PostgreSQL Versions
Client Connection Defaults / Locale and Formatting
Client Connection Defaults / Other Defaults
Client Connection Defaults / Shared Library Preloading
Client Connection Defaults / Statement Behavior
File Locations
Connections and Authentication / Connection Settings
Connections and Authentication / Security and Authentication
Error Handling
Lock Management
Query Tuning / Genetic Query Optimizer
Query Tuning / Other Planner Options
Query Tuning / Planner Cost Constants
Query Tuning / Planner Method Configuration
Replication / Master Server
Replication / Sending Servers
Replication / Standby Servers
Reporting and Logging / What to Log
Reporting and Logging / When to Log
Reporting and Logging / Where to Log
Resource Usage / Asynchronous Behavior
Resource Usage / Background Writer
Statistics / Query and Index Statistics Collector
Resource Usage / Cost-Based Vacuum Delay
Resource Usage / Disk
Resource Usage / Kernel Resources
Resource Usage / Memory
Developer Options
Version and Platform Compatibility / Other Platforms and Clients
Statistics / Monitoring
Write-Ahead Log / Archiving
Write-Ahead Log / Checkpoints
Write-Ahead Log / Settings