[openstack-dev] PostgreSQL jobs slow in the gate

Joshua Harlow harlowja at outlook.com
Thu Sep 18 00:44:53 UTC 2014


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 <joe.gordon0 at gmail.com> wrote:

> 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 <cboylan at sapwetik.org> wrote:
> Hello,
> 
> 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.
> 
> (check|gate)-tempest-dsvm-full has an average run time of 52.9 minutes
> (stddev 5.92 minutes) over 516 runs.
> (check|gate)-tempest-dsvm-postgres-full has an average run time of 73.78
> minutes (stddev 11.01 minutes) over 493 runs.
> 
> I think this is a bug and and an important one to solve prior to release
> if we want to continue to care and feed for PostgreSQL support. I
> haven't filed a bug in LP because I am not sure where the slowness is
> and creating a bug against all the projects is painful. (If there are
> suggestions for how to do this in a non painful way I will happily go
> file a proper bug).
> 
> Is there interest in fixing this? If not we should probably reconsider
> removing these PostgreSQL jobs from the gate.
> 
> 
> ++ to getting someone to own and fix this or drop it from the gate.
>  
> Note, a quick spot check indicates the increase in job time is not
> related to job setup. Total time before running tempest appears to be
> just over 18 minutes in the jobs I checked.
> 
> Thank you,
> Clark
> 
> _______________________________________________
> OpenStack-dev mailing list
> OpenStack-dev at lists.openstack.org
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
> 
> _______________________________________________
> OpenStack-dev mailing list
> OpenStack-dev at lists.openstack.org
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20140917/a68467f9/attachment.html>


More information about the OpenStack-dev mailing list