[openstack-dev] PostgreSQL jobs slow in the gate

Joe Gordon joe.gordon0 at gmail.com
Thu Sep 18 00:10:01 UTC 2014


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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20140917/a13cfdf5/attachment.html>


More information about the OpenStack-dev mailing list