Re: [Django] #26974: Support for Hash indexes

[Django]

#26974: Support for Hash indexes
-+-
 Reporter:  Akshesh Doshi|Owner:  Nick Pope
 Type:  New feature  |   Status:  assigned
Component:  Database layer   |  Version:  master
  (models, ORM)  |
 Severity:  Normal   |   Resolution:
 Keywords:  hash, index, | Triage Stage:
  postgres   |  Unreviewed
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-
Changes (by Nick Pope):

 * owner:  Akshesh Doshi => Nick Pope
 * keywords:  db-indexes => hash, index, postgres
 * stage:  Someday/Maybe => Unreviewed


Comment:

 As per my previous comment, hash indexes have been fixed in PostgreSQL 10.

 New pull request incoming...

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/062.a172e170a63fbdb7725d428e0bf70d79%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #26974: Support for Hash indexes

[Django]

#26974: Support for Hash indexes
-+-
 Reporter:  Akshesh Doshi|Owner:  Akshesh
 |  Doshi
 Type:  New feature  |   Status:  assigned
Component:  Database layer   |  Version:  master
  (models, ORM)  |
 Severity:  Normal   |   Resolution:
 Keywords:  db-indexes   | Triage Stage:
 |  Someday/Maybe
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-

Comment (by Nick Pope):

 I think this could be revisited now that PostgreSQL 10 is released and
 hash indexes have been fixed:

 - http://rhaas.blogspot.co.uk/2017/09/postgresqls-hash-indexes-are-now-
 cool.html
 - https://medium.com/@jorsol/postgresql-10-features-hash-indexes-
 484f319db281
 - https://commitfest.postgresql.org/13/740/
 - https://commitfest.postgresql.org/11/647/

 We should limit use of this index type to PostgreSQL 10 or later if that
 is possible.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/062.9416c1517cc35f9b6dbded96af2db7b5%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #26974: Support for Hash indexes

[Django]

#26974: Support for Hash indexes
-+-
 Reporter:  akki |Owner:  akki
 Type:  New feature  |   Status:  assigned
Component:  Database layer   |  Version:  master
  (models, ORM)  |
 Severity:  Normal   |   Resolution:
 Keywords:  db-indexes   | Triage Stage:
 |  Someday/Maybe
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-
Changes (by timgraham):

 * stage:  Unreviewed => Someday/Maybe


Comment:

 Given the last comment, it seems prudent to have a discussion on the
 DevelopersMailingList about whether or not to implement this.

--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/062.033a097995aa56f157817e473a8d3ae0%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #26974: Support for Hash indexes

[Django]

#26974: Support for Hash indexes
-+-
 Reporter:  akki |Owner:  akki
 Type:  New feature  |   Status:  assigned
Component:  Database layer   |  Version:  master
  (models, ORM)  |
 Severity:  Normal   |   Resolution:
 Keywords:  db-indexes   | Triage Stage:
 |  Unreviewed
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-

Comment (by pope1ni):

 I'm not sure that hash indexes are a good idea right now as they are
 currently not replication- or crash-safe.

 See the documentation: https://www.postgresql.org/docs/9.5/static/indexes-
 types.html

 It looks like some work is being done to resolve this:
 https://commitfest.postgresql.org/10/647/

--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/062.9c691f3c429162d2d257056f93595696%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #26974: Support for Hash indexes

[Django]

#26974: Support for Hash indexes
-+-
 Reporter:  akki |Owner:  akki
 Type:  New feature  |   Status:  assigned
Component:  Database layer   |  Version:  master
  (models, ORM)  |
 Severity:  Normal   |   Resolution:
 Keywords:  db-indexes   | Triage Stage:
 |  Unreviewed
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-
Changes (by akki):

 * status:  new => assigned
 * needs_better_patch:   => 0
 * needs_tests:   => 0
 * owner:  nobody => akki
 * needs_docs:   => 0
 * has_patch:  0 => 1


Comment:

 PR: https://github.com/django/django/pull/6995

--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/062.f097d97540bd12e9a70e5c12d24a21d6%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

[Django] #26974: Support for Hash indexes

[Django]

#26974: Support for Hash indexes
--+
 Reporter:  akki  |  Owner:  nobody
 Type:  New feature   | Status:  new
Component:  Database layer (models, ORM)  |Version:  master
 Severity:  Normal|   Keywords:  db-indexes
 Triage Stage:  Unreviewed|  Has patch:  0
Easy pickings:  0 |  UI/UX:  0
--+
 Adding support for using hash indexes.

 These indexes are only supported by postgresql and by only by a very
 [http://dev.mysql.com/doc/refman/5.7/en/create-index.html#create-index-
 storage-engine-index few engines] (neither InnoDB nor MyISAM though) on
 mysql.

 Also, since practically this index is supported only by postgres, would it
 be a good idea to add it to contrib.postgres ?

--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/047.7136cc5b02a4fca73c8054673d56f9b7%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.