Re: [openstack-dev] PostgreSQL jobs slow in the gate

2014-09-18 Thread Sean Dague
On 09/17/2014 11:50 PM, Clark Boylan wrote: On Wed, Sep 17, 2014, at 06:48 PM, Clark Boylan wrote: On Wed, Sep 17, 2014, at 06:37 PM, Matt Riedemann wrote: On 9/17/2014 7:59 PM, Ian Wienand wrote: On 09/18/2014 09:49 AM, Clark Boylan wrote: Recent sampling of test run times shows that our

Re: [openstack-dev] PostgreSQL jobs slow in the gate

2014-09-18 Thread Matt Riedemann
On 9/18/2014 5:49 AM, Sean Dague wrote: On 09/17/2014 11:50 PM, Clark Boylan wrote: On Wed, Sep 17, 2014, at 06:48 PM, Clark Boylan wrote: On Wed, Sep 17, 2014, at 06:37 PM, Matt Riedemann wrote: On 9/17/2014 7:59 PM, Ian Wienand wrote: On 09/18/2014 09:49 AM, Clark Boylan wrote: Recent

Re: [openstack-dev] PostgreSQL jobs slow in the gate

2014-09-18 Thread Matt Riedemann
(not for usage questions) openstack-dev@lists.openstack.org Subject: Re: [openstack-dev] PostgreSQL jobs slow in the gate Clark Boylan Wrotr : It appears that keystone eventlet is the source of the slowness in this job. With keystone eventlet all of the devstack jobs are slower and with keystone

Re: [openstack-dev] PostgreSQL jobs slow in the gate

2014-09-17 Thread Joe Gordon
Postgres is also logging a lot of errors: http://logs.openstack.org/63/122263/1/check/check-tempest-dsvm-postgres-full/2f27252/logs/postgres.txt.gz On Wed, Sep 17, 2014 at 4:49 PM, Clark Boylan cboy...@sapwetik.org wrote: Hello, Recent sampling of test run times shows that our tempest jobs

Re: [openstack-dev] PostgreSQL jobs slow in the gate

2014-09-17 Thread Joshua Harlow
Same seen @ http://logs.openstack.org/80/121280/32/check/check-tempest-dsvm-postgres-full/395a05d/logs/postgres.txt.gz Although I'm not sure if those are abnormal or not (seems likely they wouldn't be). Was there a postgres release? On Sep 17, 2014, at 5:10 PM, Joe Gordon

Re: [openstack-dev] PostgreSQL jobs slow in the gate

2014-09-17 Thread Ian Wienand
On 09/18/2014 09:49 AM, Clark Boylan wrote: Recent sampling of test run times shows that our tempest jobs run against clouds using PostgreSQL are significantly slower than jobs run against clouds using MySQL. FYI There is a possibly relevant review out for max_connections limits [1], although

Re: [openstack-dev] PostgreSQL jobs slow in the gate

2014-09-17 Thread Matt Riedemann
On 9/17/2014 7:59 PM, Ian Wienand wrote: On 09/18/2014 09:49 AM, Clark Boylan wrote: Recent sampling of test run times shows that our tempest jobs run against clouds using PostgreSQL are significantly slower than jobs run against clouds using MySQL. FYI There is a possibly relevant review

Re: [openstack-dev] PostgreSQL jobs slow in the gate

2014-09-17 Thread Clark Boylan
On Wed, Sep 17, 2014, at 06:37 PM, Matt Riedemann wrote: On 9/17/2014 7:59 PM, Ian Wienand wrote: On 09/18/2014 09:49 AM, Clark Boylan wrote: Recent sampling of test run times shows that our tempest jobs run against clouds using PostgreSQL are significantly slower than jobs run

Re: [openstack-dev] PostgreSQL jobs slow in the gate

2014-09-17 Thread Clark Boylan
On Wed, Sep 17, 2014, at 06:48 PM, Clark Boylan wrote: On Wed, Sep 17, 2014, at 06:37 PM, Matt Riedemann wrote: On 9/17/2014 7:59 PM, Ian Wienand wrote: On 09/18/2014 09:49 AM, Clark Boylan wrote: Recent sampling of test run times shows that our tempest jobs run against clouds

Re: [openstack-dev] PostgreSQL jobs slow in the gate

2014-09-17 Thread Morgan Fainberg
Clark Boylan cboy...@sapwetik.org Wrotr : On Wed, Sep 17, 2014, at 06:48 PM, Clark Boylan wrote: On Wed, Sep 17, 2014, at 06:37 PM, Matt Riedemann wrote: On 9/17/2014 7:59 PM, Ian Wienand wrote: On 09/18/2014 09:49 AM, Clark Boylan wrote: Recent sampling of test run times

Re: [openstack-dev] PostgreSQL jobs slow in the gate

2014-09-17 Thread Dean Troyer
Clark Boylan cboy...@sapwetik.org Wrotr : It appears that keystone eventlet is the source of the slowness in this job. With keystone eventlet all of the devstack jobs are slower and with keystone wsgi all of the jobs are quicker. Probably need to collect a bit more data but this doesn't

Re: [openstack-dev] PostgreSQL jobs slow in the gate

2014-09-17 Thread Morgan Fainberg
@lists.openstack.org Subject:  Re: [openstack-dev] PostgreSQL jobs slow in the gate Clark Boylan Wrotr : It appears that keystone eventlet is the source of the slowness in this job. With keystone eventlet all of the devstack jobs are slower and with keystone wsgi all of the jobs are quicker. Probably