Contributors mailing list archives

contributors@odoo-community.org

Re: Postgres Optimisation

by
andi
- 19/11/2015 08:11:05
Thanks for posting that David


With kind regards,
Mit freundlichen Grüßen,
Con un cordial saludo,
Cordialement,
с сердечным приветом,
เรื่องที่เกี่ยวกับชนิด,
與親切的問候,

 ANDI BECKER

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 transmission

On Thu, Nov 19, 2015 at 11:53 AM, David Arnold <dar@devco.co> wrote:
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

_______________________________________________
Mailing-List: http://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: http://odoo-community.org/groups?unsubscribe