IRC logs of #tryton for Friday, 2014-02-28

chat.freenode.net #tryton log beginning Fri Feb 28 00:00:01 CET 2014
2014-02-28 00:41 -!- pekka1(~pekka@cm-84.210.54.188.getinternet.no) has joined #tryton
2014-02-28 01:04 -!- digitalsatori(~Thunderbi@116.234.234.90) has joined #tryton
2014-02-28 01:06 -!- cedk(~ced@2001:6f8:3aa:1:10ec:9f63:ed26:39f8) has joined #tryton
2014-02-28 01:11 -!- cedk(~ced@85.26.36.239) has joined #tryton
2014-02-28 01:48 -!- flox(~florent@unaffiliated/flox) has joined #tryton
2014-02-28 01:50 -!- woakas1(~woakas@static.13.240.46.78.clients.your-server.de) has joined #tryton
2014-02-28 01:57 -!- gremly(~gremly@190.85.36.58) has joined #tryton
2014-02-28 01:59 -!- digitalsatori(~Thunderbi@116.234.234.90) has joined #tryton
2014-02-28 02:04 -!- udono1(~udono@ip-176-199-172-145.unitymediagroup.de) has joined #tryton
2014-02-28 02:06 -!- rafiu(~Adium@host81-139-178-190.in-addr.btopenworld.com) has joined #tryton
2014-02-28 02:15 -!- myrdd`(~myrdd@55d422c9.access.ecotel.net) has joined #tryton
2014-02-28 02:25 -!- rafiu1(~Adium@host81-139-178-190.in-addr.btopenworld.com) has joined #tryton
2014-02-28 02:30 -!- gremly(~gremly@190.85.36.58) has joined #tryton
2014-02-28 03:28 -!- digitalsatori(~Thunderbi@116.234.234.90) has joined #tryton
2014-02-28 03:40 -!- udono(~udono@ip-88-152-168-173.unitymediagroup.de) has joined #tryton
2014-02-28 05:35 -!- plantian1(~ian@174.135.6.172) has joined #tryton
2014-02-28 06:06 -!- yangoon1(~mathiasb@p549F0C0A.dip0.t-ipconnect.de) has joined #tryton
2014-02-28 06:41 -!- frispete_(~frispete@p54A9370C.dip0.t-ipconnect.de) has joined #tryton
2014-02-28 07:07 -!- LordVan(~LordVan@gentoo/developer/LordVan) has joined #tryton
2014-02-28 07:38 -!- pobsteta(~Thunderbi@4cb54-3-88-160-87-54.fbx.proxad.net) has joined #tryton
2014-02-28 08:33 -!- jvblasco(~seba@62.43.196.37.static.user.ono.com) has joined #tryton
2014-02-28 08:39 -!- jeancavallo(~giovanni@LVelizy-156-46-68-52.w80-12.abo.wanadoo.fr) has joined #tryton
2014-02-28 08:59 -!- pjstevns(~Thunderbi@2001:981:7170:1:a8b1:db7e:7673:8995) has joined #tryton
2014-02-28 09:00 -!- cons1L1(d9569fa4@gateway/web/freenode/ip.217.86.159.164) has joined #tryton
2014-02-28 09:02 -!- nicoe(~nicoe@22.78-247-81.adsl-dyn.isp.belgacom.be) has joined #tryton
2014-02-28 09:17 -!- pokoli(~pokoli@unaffiliated/pokoli) has joined #tryton
2014-02-28 09:24 <jvblasco> guys i'm having load and iowait peaks in a tryton server instance
2014-02-28 09:25 <jvblasco> centos with postgres from their repo
2014-02-28 09:25 <jvblasco> and tryton running in a virtualen with supervisor
2014-02-28 09:25 <jvblasco> i think postgres may be de culprit here
2014-02-28 09:26 <jvblasco> any tip for a postgres server tunning?
2014-02-28 09:26 <jvblasco> i form of documentation
2014-02-28 09:26 <jvblasco> in form*
2014-02-28 09:27 -!- vcardon(~vcardon@LNeuilly-152-23-15-185.w193-252.abo.wanadoo.fr) has joined #tryton
2014-02-28 09:28 <pokoli> jvblasco: maybe this article on postgresql wiki is usefull for you https://wiki.postgresql.org/wiki/Performance_Optimization
2014-02-28 09:29 <pokoli> jvblasco: have you incresed the memory of PostgreSQL? default settings are quite conservative
2014-02-28 09:44 -!- littlebit(~Thunderbi@ulmg-5d846fcf.pool.mediaWays.net) has joined #tryton
2014-02-28 10:10 <jvblasco> pokoli: i didn't, i found a python script called pgtune but i don't know how reliable it is
2014-02-28 10:11 <jvblasco> pokoli: btw i think it may be the shared memory as u are saying, cause ppl complains about psql performance in openVZ and it seems the shared memory is the culprit
2014-02-28 10:12 <jvblasco> pokoli: https://github.com/gregs1104/pgtune#readme
2014-02-28 10:12 -!- cedk(~ced@85.26.36.239) has joined #tryton
2014-02-28 10:28 <pokoli> jvblasco: I will prefer doing it manualy instead of using such script :P
2014-02-28 10:35 <jvblasco> pokoli: i will try with the script first as i need to suffocate the fire, i will need to read that wiki page though this weekend for fine tunning and gaining control over it
2014-02-28 10:36 <cedk> I find running postgresql on a virtual host, not very performant
2014-02-28 10:36 <cedk> I think it requires a lot of tunning to be good as on bare metal
2014-02-28 10:37 <cedk> also I always advise to run trytond and pg on the same host
2014-02-28 10:40 <jvblasco> they are on the same "host"
2014-02-28 10:41 <jvblasco> i think i have some problems with memory tunning
2014-02-28 10:41 <jvblasco> also the machine is 1GB RAM in an openVZ instance
2014-02-28 10:41 <jvblasco> but the postgres is killing the hypervisor with iowait and load peaks
2014-02-28 10:43 <jvblasco> if we find that opportunity cost for tunning that postgres to be there without killing the hypervisor is very high, we will do some basic tunning and move to another technology like VMWare or OpenStack
2014-02-28 10:44 <cedk> jvblasco: hahahah bare metal!
2014-02-28 10:44 <jvblasco> the thing is that an out of load tryton (just a cron action every 5 mins attacking pingdom API) was killing the hypervisor, and my guess is postgres, not tryton
2014-02-28 10:47 <pokoli> jvblasco: can I ask you about database size?
2014-02-28 10:47 <jvblasco> pokoli: almost empty
2014-02-28 10:51 <pokoli> jvblasco: I have run a 6GB on my laptop with postgresql default settings
2014-02-28 10:52 <pokoli> jvblasco: and no run iowait and load peaks
2014-02-28 10:53 <pokoli> jvblasco: so mabe the problem is how openVZ handles files
2014-02-28 10:58 <jvblasco> pokoli: i also had tenloahora oversized and didn't run into any issues. But that machine is really limited
2014-02-28 10:58 <jvblasco> pokoli: btw i think openVZ is doing some magic in the problem too
2014-02-28 11:00 -!- Telesight(~anthony@77-175-168-222.FTTH.ispfabriek.nl) has joined #tryton
2014-02-28 11:52 -!- mariomop(~quassel@181.110.66.240) has joined #tryton
2014-02-28 12:20 -!- cons1L1(d9569fa4@gateway/web/freenode/ip.217.86.159.164) has joined #tryton
2014-02-28 12:26 -!- hiaselhans(~hiaselhan@212.186.35.254) has joined #tryton
2014-02-28 12:28 -!- smarro(~sebastian@190.105.85.74) has joined #tryton
2014-02-28 12:33 -!- sharoonthomas(~sharoonth@115.243.127.100) has joined #tryton
2014-02-28 12:35 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2014-02-28 12:38 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2014-02-28 13:10 <hiaselhans> hi there, heres the guy filing some of those silly bug reports some time ago...
2014-02-28 13:11 <hiaselhans> sorry for that, but after playing around a bit with reports, i found it convenient to have the translation context inheritent aswell
2014-02-28 13:11 <hiaselhans> so i added those few lines.. should i provide a patch for that (only a few lines) or is it not of interest maybe?
2014-02-28 13:12 <udono> hiaselhans: hi, I don't understand
2014-02-28 13:13 <hiaselhans> i inherited some report from companyreport for example
2014-02-28 13:13 <hiaselhans> and set my name to something.something
2014-02-28 13:14 <hiaselhans> and in order not to provide all translation context but use the one from sale.sale instead i have to call TranslationFactory with a different class property
2014-02-28 13:15 <hiaselhans> other than __name__ which is something.something :)
2014-02-28 13:18 <udono> hiaselhans: if you think your patch could be interesting for someone else, just send it to the tryton-contrib group. If you think it should be included in main tryton, file an issue and fight your codereview ;-)
2014-02-28 13:19 <udono> hiaselhans: https://groups.google.com/forum/#!forum/tryton-contrib
2014-02-28 13:22 <hiaselhans> thanks, ill just use the mailinglist :)
2014-02-28 13:25 -!- pjstevns(~Thunderbi@2001:981:7170:1:a8b1:db7e:7673:8995) has left #tryton
2014-02-28 13:38 -!- hyances(~humberto@181.141.36.235) has joined #tryton
2014-02-28 14:06 -!- pablovannini(~pablo@181.47.176.42) has joined #tryton
2014-02-28 15:53 -!- sharoonthomas(~sharoonth@115.244.8.152) has joined #tryton
2014-02-28 16:16 -!- zodman(~zodman@50.115.163.209) has joined #tryton
2014-02-28 16:19 -!- smarro(~sebastian@181.47.135.16) has joined #tryton
2014-02-28 16:38 -!- littlebit(~Thunderbi@ulmg-5d846fcf.pool.mediaWays.net) has joined #tryton
2014-02-28 16:43 -!- pobsteta(~Thunderbi@4cb54-3-88-160-87-54.fbx.proxad.net) has joined #tryton
2014-02-28 17:29 -!- digitalsatori(~Thunderbi@114.92.199.176) has joined #tryton
2014-02-28 17:48 -!- smarro_(~sebastian@host100.190-136-175.telecom.net.ar) has joined #tryton
2014-02-28 17:52 -!- smarro(~sebastian@host100.190-136-175.telecom.net.ar) has joined #tryton
2014-02-28 17:58 -!- hyances(~humberto@181.141.36.235) has joined #tryton
2014-02-28 18:00 -!- lukio(~lukio@181.47.176.42) has joined #tryton
2014-02-28 18:14 -!- vcardon(~vcardon@LNeuilly-152-23-15-185.w193-252.abo.wanadoo.fr) has left #tryton
2014-02-28 18:28 -!- digitalsatori(~Thunderbi@114.92.199.176) has joined #tryton
2014-02-28 18:31 -!- lukio(~lukio@181.47.176.42) has left #tryton
2014-02-28 18:43 -!- littlebit(~Thunderbi@ulmg-5d846fcf.pool.mediaWays.net) has joined #tryton
2014-02-28 18:50 -!- cedk(~ced@85.26.36.239) has joined #tryton
2014-02-28 18:50 -!- zodman(~zodman@50.115.163.209) has joined #tryton
2014-02-28 18:52 -!- mariomop(~quassel@181.110.66.240) has joined #tryton
2014-02-28 18:54 -!- sisalp(~sisalpuse@gratoox.sisalp.net) has joined #tryton
2014-02-28 19:02 -!- zodman(~zodman@50.115.163.209) has joined #tryton
2014-02-28 19:15 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2014-02-28 19:38 -!- pobsteta(~Thunderbi@4cb54-3-88-160-87-54.fbx.proxad.net) has joined #tryton
2014-02-28 21:22 -!- pablovannini(~pablo@181.47.176.42) has joined #tryton
2014-02-28 21:52 -!- hyances(~humberto@181.141.36.235) has joined #tryton
2014-02-28 23:30 -!- zodman(~zodman@50.115.163.209) has joined #tryton
2014-02-28 23:39 -!- zodman(~zodman@50.115.163.209) has joined #tryton
2014-02-28 23:43 -!- ArtGravity(~artgravit@2602:47:d89d:b600:7003:f174:5b10:713b) has joined #tryton

Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!