Comment 2 for bug 1394426

I suggest adding an index on "oops_oops"."oopsinfestation_id

On 20 November 2014 14:19, Ryan Finnie <email address hidden> wrote:
> Appears to be http://stackoverflow.com/questions/21385555/postgresql-
> query-very-slow-with-limit-1 . Changing "LIMIT 1" to "LIMIT 50" returns
> results immediately.
>
> --
> You received this bug notification because you are subscribed to
> Launchpad Suite.
> https://bugs.launchpad.net/bugs/1394426
>
> Title:
> oopses part of large infestations take forever to load
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/python-oops-tools/+bug/1394426/+subscriptions

--
Robert Collins <email address hidden>
Distinguished Technologist
HP Converged Cloud