Contributors mailing list archives

contributors@odoo-community.org

Re: Postgres Optimisation

by
dar@devco.co
- 23/11/2015 17:08:32

Hi Ray and Graeme,

I really appreciate you're input!
Graeme, I understand your point. And it'll take me some time to fully digest your input. Thank you for that. It seems (obvious for many) that besides some logging best practices (which is already a huge thing) optimisation takes place on DB maintenance.

I think with this I can start a blog post for people feeling uncomfortable to start, like I do/did.

As to settings defaults, there seem to be just some very insensible and conservative defaults. (Eg. Still very low default work_mem for modern hardware) Knowing that feels uncomfortable, less so if you can't judge if it's the 20% or the 80% which is itching there...

Thanks again! I very much appreciate the input! Thanks to the input of others as well, which I still need to discover while I'm working myself through the flame stack.

Good Day!

Lithin Thampan <lithint.mail@gmail.com> schrieb am Fr., 20. Nov. 2015 um 14:38:
Hi,
Did anyone tried http://www.postgresql.org/docs/current/static/high-availability.html in odoo database? Will this help to balance the load within the postgres ?

On Fri, Nov 20, 2015 at 7:08 PM, Yannick Vaucher <yannick.vaucher@camptocamp.com> wrote:
A little reminder of the purpose of this mailing list (with link):

https://odoo-community.org/groups
"This group is meant for both OCA contributors (members or not) to discuss the development of OCA projects. It can serve as a place to exchange on project roadmaps, discuss cross project issues... "

In my opinion, asking for tutorials on how to deploy Odoo or improving postgres performance is quite out of context of OCA projects.

You might want to discuss this on the official odoo community mailing list : https://www.odoo.com/page/odoo-community
Or post your answer on https://www.odoo.com/forum/help-1

Regards,

Yannick Vaucher
Business Solutions Software Developer

Camptocamp SA
PSE A, CH-1015 Lausanne
Phone: +41 21 619 10 30
Office: +41 21 619 10 10

On Fri, Nov 20, 2015 at 3:52 PM, Andreas Becker <andi@lisandi.com> wrote:
Thanks for posting the links Nhomar - It is actually more to help those people we train here at schools and universities to be interested in Odoo and its possibilities as a tool for accounting, for web design, for seo marketing, for programming at all, for learning about workflows, for understanding databases etc. and even licensing and malware integration or explaining what a phone home functionality is doing and how to discover it. 

There is so much you can use Odoo for in educational institutions and IMHO Odoo should be integrated in the curriculum like it had been integrated in France already. But most of the IT teachers/Professors/Students have very weak or even nearly no English proficiency and have real problems to find things because they spell the search terms the wrong way or because they try to get help by google translate, which is often no help at all in those tone languages.

" I "feel " like you want the job done without respect other's people time."

Simply respect people who want to learn the same way you have been respected when you were a learner and beginner and be now a good teacher to them. By the way nobody forces anybody to respond at all, but also it would be nice not to try to block efforts like David Arnold has started right at the beginning!

Thanks for the idea by using http://lmgtfy.com - didn't know about that page - nice!

Here is the Thai Version: i.e. a user copy pastes your suggestion of 


Perhaps you know now what I mean - Our people here can't simply find those things you mention, even they key in the search words in Thai language. You can also try other synonyms. 

To help our people here we train them in English but it would be really great to have always the correct links to the correct resources available in those threads as Google often does not help because the people don't know how to spell correctly.

Now after you have posted the correct spelling they are able to find it - 
Thanks a lot - and you helped them to learn a bit more on their way to better English Proficiency and they now will find also documents about performance of postgres!

For all those who are still searching for the Oliver Dony Presntation - here it is:

You will find this slideshare of Oliver Dony much easier if you add "+ odoo" to the search terms Nhomar has posted. 






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

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 Fri, Nov 20, 2015 at 8:46 PM, Andreas Becker <andi@lisandi.com> wrote:
exactly and I think it is good to have that discussion and it should not be stopped by those who only direct to already existing documentations without even posting links to them!

So let's continue with what David Arnold had started also to help others!

Thanks!


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

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 Fri, Nov 20, 2015 at 8:08 PM, <Mozetič@pad.odoo-community.org> wrote:

What's the flaming useful for? Somebody proposes an open discussion. If somebody else doesn't want to discuss...  Don't.

On Nov 20, 2015 1:53 PM, "Houssine BAKKALI" <houssine.bakkali@gmail.com> wrote:
"Hire an expert does not solve the problem of those who want to learn to do things by themselves,"

take a training then

2015-11-20 13:37 GMT+01:00 Andreas Becker <andi@lisandi.com>:

On Fri, Nov 20, 2015 at 3:07 PM, Leonardo Pistone <lpistone@gmail.com> wrote:
- I think rewriting all the documentation of postgresql, going through every feature and option, for odoo is the wrong approach.

No it is not the wrong approach but it could be a great addition for people who want to start working with odoo at all. You don't need at all the whole postgre knowledge to run odoo but you need to know how probably to improve some parts of odoo, where postgres is playing a role in.
 
The original documentation of postgresql is the best place, and it is excellent.

If the original documentation which not even mentions odoo would be such excellent and understandable, peolpe would not have made such a request here at oodo. Simply stop blocking those initiatives which perhaps will even help a complete newbie with odoo or postgres to understand things easily. Instead help to let people know how things are working with postgres and explain them in detail and with lots of images and examples how it does this and that and perhaps even compare it with mysql or mariadb's new complete encrypted way. While you explain that you will Always use ODOO examples and this will drive even developers and people who have never before heard of Odoo towards an application they will start liking more and more. Even they were not specifically looking at it. Those Odoo specific Tutorials concerning Postgres and perhaps also some other additional applications will drive more and more people towards odoo and this will not help when you always write down here that people look at postgres look at whatever app which is not postgres but wich is essentially needed to get postgres running at all.

Simply try to move in the position of these people and try to understand their request for this additional documentation and help them to find their way!
 
- check out Olivier Dony's talk for advice specific to Odoo

Where can we find that talk - please add a link! - Nothing more I was asking - when you write on a mailinglist provide "look here , look that talk, check out google etc" without the links for those who simply can't find them, your comment is nothing else than worthless even for people who are searching via google for a solution for their problems. It is the same with people who you provide help and help and again help and ideas and than finally your read. "Thanks it is running now" and that's it. Most not even provide others the help they just received and simply summarize what their solution for their problem was.

When you think that everybody can find that links you are completely wrong! Some developers have not such English or Spanish or French proficiency and can't find things they have probably written wrong in their search terms. 

i.e. you get project which requires you to integrate the Thai chart of accounts in their newest version. Try to find them!


You will get i.e.
well this will drive people to Front accounting and does not solve the problem for odoo.

wow great you will find that here which has been programmed here in Phuket by somebody who suddenly died and meanwhile this software does not even get anymore maintained. will it help you - simple answer NO.

But if you are lucky you will find someone who can tell you where on yor keyboard you will find the Thai letters ;-)

By the way P̄hạng bạỵchī will lead you to lots of links from vietnam ;-) - This is what google is translating "chart of accounts"


Making it short you have a great chance to fail like those who are trying to learn more about what postgres is doing for odoo and who don't like to figure out if this or that is even needed for odoo.

Y
 
- with recent postgresql start with defaults (+ Olivier's advice) - there isn't a "perfect" copy-paste configuration of Odoo. If you have performance problems, copy-paste won't help,

Copy paste helps a lot of people who learn what they are doing and who want to understand how things are done. "Help to do it by myself" Principle which provides the students a well prepared surrounding where they even are allowed to do mistakes without greater harm.
 
but instead you need some analysis, checking your blocked and long queries, indexes, 'explain analyze' and so on.

Learning by example is the best way to start analyzing and reflecting its own habits and way to do things. This is also valid when you do programming.
 
This knowledge is not at all odoo-specific: you can study the postgresql documentation, hire an expert, or both. - No, I do not mean "hire me".

Hire an expert does not solve the problem of those who want to learn to do things by themselves, 




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

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

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


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

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



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


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




--
Thanks & Regards,

Lithin T
Software Engineer
Mob  : +971556712557(UAE)
Mail  : lithint.mail@gmail.com | Skype : lithint.skype

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