Contributors mailing list archives
contributors@odoo-community.org
Browse archives
Postgres Optimisation
by
dar@devco.co
Hi
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: https://goo.gl/DPfDwK
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"
AND/XOR
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: http://de.slideshare.net/openobject/performance2014-35689113
PostgreSQL guides:
Best Regards and thanks for your interest
David
| Autovacuum |
| 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 |
Follow-Ups
