]> git.ipfire.org Git - thirdparty/patchwork.git/commit
Add covering index to patchwork_submissions for /list/ queries
authorStewart Smith <stewart@linux.ibm.com>
Fri, 10 Aug 2018 08:01:03 +0000 (18:01 +1000)
committerStephen Finucane <stephen@that.guru>
Mon, 10 Sep 2018 20:24:24 +0000 (14:24 -0600)
commit332956146469575c3ceeb3ecd94c7459e1e3dbea
treeb3c38f925f41a0e3d5368a4fb524615830ddb822
parent5b8b6fb5261dc2cb1c95bc82ab7a5466e6699d03
Add covering index to patchwork_submissions for /list/ queries

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 <stewart@linux.ibm.com>
[stephenfin: Regenerate migrations per addition of 0027 in earlier
 patch]
Signed-off-by: Stephen Finucane <stephen@that.guru>
patchwork/migrations/0030_add_submission_covering_index.py [new file with mode: 0644]
patchwork/models.py