pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Doc: indexUnchanged is strictly a hint. 4+ messages / 1 participants [nested] [flat]
* pgsql: Doc: indexUnchanged is strictly a hint. @ 2023-10-24 16:27 Peter Geoghegan <pg@bowt.ie> 0 siblings, 0 replies; 4+ messages in thread From: Peter Geoghegan @ 2023-10-24 16:27 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Doc: indexUnchanged is strictly a hint. Clearly spell out the limitations of aminsert()'s indexUnchanged hinting mechanism in the index AM documentation. Oversight in commit 9dc718bd, which added the "logically unchanged index" hint (which is used to trigger bottom-up index deletion). Author: Peter Geoghegan <pg@bowt.ie> Reported-By: Tom Lane <tgl@sss.pgh.pa.us> Reviewed-By: Tom Lane <tgl@sss.pgh.pa.us> Discussion: https://postgr.es/m/CAH2-WzmU_BQ=-H9L+bxTSMQBqHMjp1DSwGypvL0gKs+dTOfkKg@mail.gmail.com Backpatch: 14-, where indexUnchanged hinting was introduced. Branch ------ REL_15_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/be2502947f299a8f8f076e49eb74289558654368 Modified Files -------------- doc/src/sgml/indexam.sgml | 10 +++++++--- 1 file changed, 7 insertions(+), 3 deletions(-) ^ permalink raw reply [nested|flat] 4+ messages in thread
* pgsql: Doc: indexUnchanged is strictly a hint. @ 2023-10-24 16:27 Peter Geoghegan <pg@bowt.ie> 0 siblings, 0 replies; 4+ messages in thread From: Peter Geoghegan @ 2023-10-24 16:27 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Doc: indexUnchanged is strictly a hint. Clearly spell out the limitations of aminsert()'s indexUnchanged hinting mechanism in the index AM documentation. Oversight in commit 9dc718bd, which added the "logically unchanged index" hint (which is used to trigger bottom-up index deletion). Author: Peter Geoghegan <pg@bowt.ie> Reported-By: Tom Lane <tgl@sss.pgh.pa.us> Reviewed-By: Tom Lane <tgl@sss.pgh.pa.us> Discussion: https://postgr.es/m/CAH2-WzmU_BQ=-H9L+bxTSMQBqHMjp1DSwGypvL0gKs+dTOfkKg@mail.gmail.com Backpatch: 14-, where indexUnchanged hinting was introduced. Branch ------ REL_16_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/cf89d3052d62a5dd82805d157b64cdf493e5e851 Modified Files -------------- doc/src/sgml/indexam.sgml | 10 +++++++--- 1 file changed, 7 insertions(+), 3 deletions(-) ^ permalink raw reply [nested|flat] 4+ messages in thread
* pgsql: Doc: indexUnchanged is strictly a hint. @ 2023-10-24 16:27 Peter Geoghegan <pg@bowt.ie> 0 siblings, 0 replies; 4+ messages in thread From: Peter Geoghegan @ 2023-10-24 16:27 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Doc: indexUnchanged is strictly a hint. Clearly spell out the limitations of aminsert()'s indexUnchanged hinting mechanism in the index AM documentation. Oversight in commit 9dc718bd, which added the "logically unchanged index" hint (which is used to trigger bottom-up index deletion). Author: Peter Geoghegan <pg@bowt.ie> Reported-By: Tom Lane <tgl@sss.pgh.pa.us> Reviewed-By: Tom Lane <tgl@sss.pgh.pa.us> Discussion: https://postgr.es/m/CAH2-WzmU_BQ=-H9L+bxTSMQBqHMjp1DSwGypvL0gKs+dTOfkKg@mail.gmail.com Backpatch: 14-, where indexUnchanged hinting was introduced. Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/74e5ea1e002f861d499ded6562cab9e769f44781 Modified Files -------------- doc/src/sgml/indexam.sgml | 10 +++++++--- 1 file changed, 7 insertions(+), 3 deletions(-) ^ permalink raw reply [nested|flat] 4+ messages in thread
* pgsql: Doc: indexUnchanged is strictly a hint. @ 2023-10-24 16:27 Peter Geoghegan <pg@bowt.ie> 0 siblings, 0 replies; 4+ messages in thread From: Peter Geoghegan @ 2023-10-24 16:27 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Doc: indexUnchanged is strictly a hint. Clearly spell out the limitations of aminsert()'s indexUnchanged hinting mechanism in the index AM documentation. Oversight in commit 9dc718bd, which added the "logically unchanged index" hint (which is used to trigger bottom-up index deletion). Author: Peter Geoghegan <pg@bowt.ie> Reported-By: Tom Lane <tgl@sss.pgh.pa.us> Reviewed-By: Tom Lane <tgl@sss.pgh.pa.us> Discussion: https://postgr.es/m/CAH2-WzmU_BQ=-H9L+bxTSMQBqHMjp1DSwGypvL0gKs+dTOfkKg@mail.gmail.com Backpatch: 14-, where indexUnchanged hinting was introduced. Branch ------ REL_14_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/df73ca35144a8711e42b82cd147ee34407553b3c Modified Files -------------- doc/src/sgml/indexam.sgml | 10 +++++++--- 1 file changed, 7 insertions(+), 3 deletions(-) ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2023-10-24 16:27 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2023-10-24 16:27 pgsql: Doc: indexUnchanged is strictly a hint. Peter Geoghegan <pg@bowt.ie> 2023-10-24 16:27 pgsql: Doc: indexUnchanged is strictly a hint. Peter Geoghegan <pg@bowt.ie> 2023-10-24 16:27 pgsql: Doc: indexUnchanged is strictly a hint. Peter Geoghegan <pg@bowt.ie> 2023-10-24 16:27 pgsql: Doc: indexUnchanged is strictly a hint. Peter Geoghegan <pg@bowt.ie>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox