[Django] #32943: Add support for covering indexes and exclusion constraints for SP-GiST in PostgreSQL 14+.

23 views
Skip to first unread message

Django

unread,
Jul 19, 2021, 7:16:10 AM7/19/21
to django-...@googlegroups.com
#32943: Add support for covering indexes and exclusion constraints for SP-GiST in
PostgreSQL 14+.
-------------------------------------+-------------------------------------
Reporter: Nick Pope | Owner: Nick Pope
Type: New | Status: assigned
feature |
Component: | Version: dev
contrib.postgres | Keywords: postgresql, spgist,
Severity: Normal | index, exclusion, constraint,
Triage Stage: | include, covering
Unreviewed | Has patch: 0
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
PostgreSQL 14+ will support covering indexes and exclusion constraints
using SP-GiST.

See https://www.postgresql.org/docs/release/14.0/

--
Ticket URL: <https://code.djangoproject.com/ticket/32943>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

Django

unread,
Jul 19, 2021, 2:13:08 PM7/19/21
to django-...@googlegroups.com
#32943: Add support for covering indexes and exclusion constraints for SP-GiST in
PostgreSQL 14+.
-------------------------------------+-------------------------------------
Reporter: Nick Pope | Owner: Nick Pope
Type: New feature | Status: assigned
Component: contrib.postgres | Version: dev
Severity: Normal | Resolution:
Keywords: postgresql, spgist, | Triage Stage:
index, exclusion, constraint, | Someday/Maybe
include, covering |

Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Mariusz Felisiak):

* stage: Unreviewed => Someday/Maybe


--
Ticket URL: <https://code.djangoproject.com/ticket/32943#comment:1>

Django

unread,
Jul 23, 2021, 11:50:21 AM7/23/21
to django-...@googlegroups.com
#32943: Add support for covering indexes and exclusion constraints for SP-GiST in
PostgreSQL 14+.
-------------------------------------+-------------------------------------
Reporter: Nick Pope | Owner: Nick Pope
Type: New feature | Status: assigned
Component: contrib.postgres | Version: dev
Severity: Normal | Resolution:
Keywords: postgresql, spgist, | Triage Stage:
index, exclusion, constraint, | Someday/Maybe
include, covering |
Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Nick Pope):

* has_patch: 0 => 1


Comment:

[https://github.com/django/django/pull/14663 Draft PR] pending this being
accepted.

PostgreSQL 14 should be released in late September or early October based
on the last five major releases.
Django 4.0 feature freeze is scheduled for 20th September with final
release on 6th December.

If all goes well we could perhaps consider landing this before the feature
freeze when a PostgreSQL 14 release candidate is available.

--
Ticket URL: <https://code.djangoproject.com/ticket/32943#comment:2>

Reply all
Reply to author
Forward
0 new messages