yahoo-eng-team team mailing list archive

[Thierry Carrez <thierry.carrez+lp@xxxxxxxxx>]

** Changed in: neutron
       Status: Fix Committed => Fix Released

** Changed in: neutron
    Milestone: None => kilo-3

-- 
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):
  Fix Released

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