yahoo-eng-team team mailing list archive

Thread
Date

[Bug 1214830] Re: add missing index for 'owner' column on images table

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Thierry Carrez <thierry.carrez+lp@xxxxxxxxx>
Date: Wed, 02 Oct 2013 15:46:33 -0000
Reply-to: Bug 1214830 <1214830@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx

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

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

Title:
  add missing index for 'owner' column on images table

Status in OpenStack Image Registry and Delivery Service (Glance):
  Fix Released

Bug description:
  The image-list query involves fetching of images by images.owner.
  Because there is an index missing on the owner column, a full table
  scan is done while filtering for images.

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