pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Allow _h_indexbuild() to be interrupted. 7+ messages / 1 participants [nested] [flat]
* pgsql: Allow _h_indexbuild() to be interrupted. @ 2024-09-13 20:17 Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 7+ messages in thread From: Tom Lane @ 2024-09-13 20:17 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Allow _h_indexbuild() to be interrupted. When we are building a hash index that is large enough to need pre-sorting (larger than either maintenance_work_mem or NBuffers), the initial sorting phase is interruptible, but the insertion phase wasn't. Add the missing CHECK_FOR_INTERRUPTS(). Per bug #18616 from Alexander Lakhin. Back-patch to all supported branches. Pavel Borisov Discussion: https://postgr.es/m/18616-acbb9e5caf41e964@postgresql.org Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/fae55f0bb38504b3774fa50152d3c14d2f09aa15 Modified Files -------------- src/backend/access/hash/hashsort.c | 3 +++ 1 file changed, 3 insertions(+) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Allow _h_indexbuild() to be interrupted. @ 2024-09-13 20:17 Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 7+ messages in thread From: Tom Lane @ 2024-09-13 20:17 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Allow _h_indexbuild() to be interrupted. When we are building a hash index that is large enough to need pre-sorting (larger than either maintenance_work_mem or NBuffers), the initial sorting phase is interruptible, but the insertion phase wasn't. Add the missing CHECK_FOR_INTERRUPTS(). Per bug #18616 from Alexander Lakhin. Back-patch to all supported branches. Pavel Borisov Discussion: https://postgr.es/m/18616-acbb9e5caf41e964@postgresql.org Branch ------ REL_13_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/b27215dbb42b6376515e1ab1ff06e0ad9ab13450 Modified Files -------------- src/backend/access/hash/hashsort.c | 3 +++ 1 file changed, 3 insertions(+) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Allow _h_indexbuild() to be interrupted. @ 2024-09-13 20:17 Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 7+ messages in thread From: Tom Lane @ 2024-09-13 20:17 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Allow _h_indexbuild() to be interrupted. When we are building a hash index that is large enough to need pre-sorting (larger than either maintenance_work_mem or NBuffers), the initial sorting phase is interruptible, but the insertion phase wasn't. Add the missing CHECK_FOR_INTERRUPTS(). Per bug #18616 from Alexander Lakhin. Back-patch to all supported branches. Pavel Borisov Discussion: https://postgr.es/m/18616-acbb9e5caf41e964@postgresql.org Branch ------ REL_17_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/418c6a2c72d22dd3810d08cd06af6126b8bbd4b1 Modified Files -------------- src/backend/access/hash/hashsort.c | 3 +++ 1 file changed, 3 insertions(+) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Allow _h_indexbuild() to be interrupted. @ 2024-09-13 20:17 Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 7+ messages in thread From: Tom Lane @ 2024-09-13 20:17 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Allow _h_indexbuild() to be interrupted. When we are building a hash index that is large enough to need pre-sorting (larger than either maintenance_work_mem or NBuffers), the initial sorting phase is interruptible, but the insertion phase wasn't. Add the missing CHECK_FOR_INTERRUPTS(). Per bug #18616 from Alexander Lakhin. Back-patch to all supported branches. Pavel Borisov Discussion: https://postgr.es/m/18616-acbb9e5caf41e964@postgresql.org Branch ------ REL_14_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/b49013f2e86ad2cf01953f79992574e7ec2cdf02 Modified Files -------------- src/backend/access/hash/hashsort.c | 3 +++ 1 file changed, 3 insertions(+) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Allow _h_indexbuild() to be interrupted. @ 2024-09-13 20:17 Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 7+ messages in thread From: Tom Lane @ 2024-09-13 20:17 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Allow _h_indexbuild() to be interrupted. When we are building a hash index that is large enough to need pre-sorting (larger than either maintenance_work_mem or NBuffers), the initial sorting phase is interruptible, but the insertion phase wasn't. Add the missing CHECK_FOR_INTERRUPTS(). Per bug #18616 from Alexander Lakhin. Back-patch to all supported branches. Pavel Borisov Discussion: https://postgr.es/m/18616-acbb9e5caf41e964@postgresql.org Branch ------ REL_12_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/813ade54806c0bce9a0b74db4e7977f9d0be0185 Modified Files -------------- src/backend/access/hash/hashsort.c | 3 +++ 1 file changed, 3 insertions(+) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Allow _h_indexbuild() to be interrupted. @ 2024-09-13 20:17 Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 7+ messages in thread From: Tom Lane @ 2024-09-13 20:17 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Allow _h_indexbuild() to be interrupted. When we are building a hash index that is large enough to need pre-sorting (larger than either maintenance_work_mem or NBuffers), the initial sorting phase is interruptible, but the insertion phase wasn't. Add the missing CHECK_FOR_INTERRUPTS(). Per bug #18616 from Alexander Lakhin. Back-patch to all supported branches. Pavel Borisov Discussion: https://postgr.es/m/18616-acbb9e5caf41e964@postgresql.org Branch ------ REL_15_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/e0857898b87b745235e65c28feed6e23e121876d Modified Files -------------- src/backend/access/hash/hashsort.c | 3 +++ 1 file changed, 3 insertions(+) ^ permalink raw reply [nested|flat] 7+ messages in thread
* pgsql: Allow _h_indexbuild() to be interrupted. @ 2024-09-13 20:17 Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 7+ messages in thread From: Tom Lane @ 2024-09-13 20:17 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Allow _h_indexbuild() to be interrupted. When we are building a hash index that is large enough to need pre-sorting (larger than either maintenance_work_mem or NBuffers), the initial sorting phase is interruptible, but the insertion phase wasn't. Add the missing CHECK_FOR_INTERRUPTS(). Per bug #18616 from Alexander Lakhin. Back-patch to all supported branches. Pavel Borisov Discussion: https://postgr.es/m/18616-acbb9e5caf41e964@postgresql.org Branch ------ REL_16_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/d23109f4bd65ef217dbd72846afa949927640463 Modified Files -------------- src/backend/access/hash/hashsort.c | 3 +++ 1 file changed, 3 insertions(+) ^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2024-09-13 20:17 UTC | newest] Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-09-13 20:17 pgsql: Allow _h_indexbuild() to be interrupted. Tom Lane <tgl@sss.pgh.pa.us> 2024-09-13 20:17 pgsql: Allow _h_indexbuild() to be interrupted. Tom Lane <tgl@sss.pgh.pa.us> 2024-09-13 20:17 pgsql: Allow _h_indexbuild() to be interrupted. Tom Lane <tgl@sss.pgh.pa.us> 2024-09-13 20:17 pgsql: Allow _h_indexbuild() to be interrupted. Tom Lane <tgl@sss.pgh.pa.us> 2024-09-13 20:17 pgsql: Allow _h_indexbuild() to be interrupted. Tom Lane <tgl@sss.pgh.pa.us> 2024-09-13 20:17 pgsql: Allow _h_indexbuild() to be interrupted. Tom Lane <tgl@sss.pgh.pa.us> 2024-09-13 20:17 pgsql: Allow _h_indexbuild() to be interrupted. Tom Lane <tgl@sss.pgh.pa.us>
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