Re: [PATCH 08/11] Add covering index to patchwork_submissions for /list/ queries

2018-08-31 Thread Stephen Finucane
On Fri, 2018-08-10 at 18:01 +1000, Stewart Smith wrote: > This gets PostgreSQL to generate *much* better query plans, gaining us > about two orders of magnitude in performance on the /list/ query for the > worst state project on the patchwork.ozlabs.org instance (qemu-devel). > > Signed-off-by:

[PATCH 08/11] Add covering index to patchwork_submissions for /list/ queries

2018-08-10 Thread Stewart Smith
This gets PostgreSQL to generate *much* better query plans, gaining us about two orders of magnitude in performance on the /list/ query for the worst state project on the patchwork.ozlabs.org instance (qemu-devel). Signed-off-by: Stewart Smith --- .../0029_add_submission_covering_index.py |