Contributors mailing list archives
contributors@odoo-community.org
Browse archives
Re: Postgres Optimisation
by
andi
Thanks for posting that David
With kind regards,
Mit freundlichen Grüßen,
Con un cordial saludo,
Cordialement,
с сердечным приветом,
เรื่องที่เกี่ยวกับชนิด,
與親切的問候,
CEO/General Manager LisAndi Co., Ltd.
LisAndi Co. Ltd., Phuket, Thailand (lisandi.com)
15/21 M.2 Viset Road, Rawai, Muang, Phuket, Thailand 83130
Mobile: +66 (0)81 606 3378
VoIP: +49 (0)711 50 88788 50
Fax: +49 (0)711 50 88788 50
Skype: lisandi
Facebook: andibecker
Google Talk/Facetime/eMail: andi@lisandi.com
--------------------------------------------------
This email may contain confidential and/or privileged information. If you are not the intended recipient (or have received this email by mistake), please notify the sender immediately and destroy this email. Any unauthorized copying, disclosure or distribution of the material in this email is strictly prohibited. Email transmission security and error-free status cannot be guaranteed as information could be intercepted, corrupted, destroyed, delayed, incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which may arise as a result of email transmissionOn Thu, Nov 19, 2015 at 11:53 AM, David Arnold <dar@devco.co> wrote:
Hiis 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/DPfDwKIf 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/XORIf 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-35689113PostgreSQL guides:Best Regards and thanks for your interestDavid
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 _______________________________________________
Mailing-List: http://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: http://odoo-community.org/groups?unsubscribe
