yahoo-eng-team team mailing list archive

[Ann Kamyshnikova <akamyshnikova@xxxxxxxxxxxx>]

Public bug reported:

Adding index on tenant_id could greatly speed up SELECTs with filters by tenant_id when some value is selected per resource
per tenant.

Simple example with adding index on securitygrouprules show that speed could increase twice.
For  MySQL http://paste.openstack.org/show/169810/
For PostgreSQL http://paste.openstack.org/show/169957/

** Affects: neutron
     Importance: Undecided
         Status: New


** Tags: db

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1419815

Title:
  Speed up SELECTs with filters by tenant_id

Status in OpenStack Neutron (virtual network service):
  New

Bug description:
  Adding index on tenant_id could greatly speed up SELECTs with filters by tenant_id when some value is selected per resource
  per tenant.

  Simple example with adding index on securitygrouprules show that speed could increase twice.
  For  MySQL http://paste.openstack.org/show/169810/
  For PostgreSQL http://paste.openstack.org/show/169957/

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1419815/+subscriptions