Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pwqwF-0005MN-2j for pgsql-admin@arkaria.postgresql.org; Wed, 10 May 2023 21:01:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pwqwE-0004eD-1n for pgsql-admin@arkaria.postgresql.org; Wed, 10 May 2023 21:01:30 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pwqwD-0004e3-IK for pgsql-admin@lists.postgresql.org; Wed, 10 May 2023 21:01:29 +0000 Received: from sonic313-9.consmr.mail.ne1.yahoo.com ([66.163.185.32]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1pwqwA-001qdt-I7 for pgsql-admin@lists.postgresql.org; Wed, 10 May 2023 21:01:28 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1683752483; bh=EtMGiXd73LxXdOSqhD/ckMWPGpZRF9dW2oBTuTXkT7c=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=IZcjVQPB9OulXZ7UmW0g3DCcx87RfunlrDhCE9+Ji5h/fzyNhhLVhTax3aB9ofDrKrx/YFkFg6xCxBHdkqz9DVelblM7n8QtKUkZev9g7cPe9ATN+XZd/2CWi2TmdPevYn9KTV0PGJ/i6brHICLsrN4+b81MVPEB2La6oKjroHMLQlGrOF8nX1SDL/loKZu1+ezWHCwS4rtdc4VFixI6xW8IlJ1urkOCv0wDWI1kqcHkLqHkA62f9mZePf097e0im1T4oHgQ5RnH22R11oDpW1EL2le8NrRk0eGZxor2zk1FXUT+UdDxbDCkf9KbKNOlqc8JFlomcdJHKOwcjqiBjQ== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1683752483; bh=8b1gfvJ7ddrVENcCYbKYMCLNSa8DZKPDCG/NBx4J0oX=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=ScCecos4Axmrb4T9Rted2Cx31gUgFRBZHMWWcMJ8WwBbcdrmfMMEJm4oKJ/dJphORVTHDVVJKeu8QpI9SSvDZRYCL5Bp3sWEDHxw3AQ4ivXOMr44zIV22AwComt5HJOc9VaS9kl2kcE+XvUR40BwlyYmYDAmP6fBaBPm6Imz8efGKT2qb7LjzBf9AeQYan7kjOo7XFKrGBNbtk7hKLTE0tTI0WHJ1ChaBNq637mzg+bm74OsCmtJ7DOjbwYRduF7DAnwftrVQz0qWmv48mPHn12mhkZ4aavD9Ki8vzNnZjUbS5QoXn/CN0wByo3fLf2M15dEbOSbYOVukR+P45HtpA== X-YMail-OSG: 5Ey315wVM1nySDUi1vNrz_xbgcXmrZ0FCDQy5uplktd_wlKm5fymSG8xxEK60ZG XuGqalLvPZ.4IkueLSI61ymCIVgYDIsophYrDC7Qk96fmzJpW0hqtLP99fbI7hA05U8TfdE5RAfS XPyxIsroBgAOqn5YWYC93b6qnaU2_TKcW6zpmS6GR4t1mdqRlvUI6nX42ax3cjghL7c.UEiPtOLv cSUHmRgTbl6G1qHcyGVyqaa5T7oEv59M7p2AvrmU2x4dMfXZbPArBe.3UlubMS6ezLGMeScwiEmb PHWM1TfyfMlWlhPk7qsIWp5C_yOnNyMPypKUcBDSVifGFqL7FHNelg._fEUr8O4hJeX.T3GzI5UT oI5UiJPRdXLIkxlTFoQSiA3S5VejllDk9MRzp74_9oK7UkGJQajnCKbRoZFqbBqbTtLu0B76wQK4 pB88SW3EG4JbiqzBYQG_hSSfh_adHTw548KH23486bnGz.qCiRXnhWzfOkNlFaQ5Avz0jb0_yhQS FtSBRr48Im6mj1Llt42xmdBY8tB7ugPkJR2tjEDa7KBzprMaG6YjjN.bS9FKaBJkKnOkAhh1ohXs 4mz7hXpimt9nevD.pg4qnVYPNV3HLx5_VcTqK.n6B3vrky5T.X18Jm0_TS5M0NUgAvLNGJZlDuwy MV_sW1ea.j5uWPJwXR8NUuScah7z5t4vH0KvIt0wH.d_1mVL5zYS7ochD1jJcKL6awZqM4Dr_g0R nyEHYqzqGsd2rCxDAM.AvmtHPpoIEVyjUfHum70aAJ1GoN.o39KSPQApf159THSgB56VI.8PaQF1 xNLT5FHJkbYJIy3n6WugXMA.N2UNEEeeS74E9rJmU9vWosO7JnVe13L0HO4w97y0Mfz1YHT_l2YZ VdX8b7R4MLg1Y.iEj2cZoe3bTcv2x24c39iL9ohn8fMFqLEGBEBPN2orO51kV4Q7i0uZrstQOOcx lJvacNGedYu__y64A8Yk9QfR395pkatBD.4IWsje5UmJXWcRazBqLt55hcg.iOk6VWKpZ_A8.zUg Gk5OFTVqjzm7XkcOJ6UpgfV_ZblGcUhvUQTWsNBFWGbuCySMS.MkDDNBjqjzswIOvGvs6h6jsBs5 qOTr0189DEkDmIrk1iRsOgflWV6XK6CidS6uXQCJQyNkb_3_OMh3OzYlUozppjM5MOFzDtiv_XqT WAkVxAi3ZTcMCiWVxppqurpqVIiHafSYSmrk5hpv25..yU3q6qb2alrTTqd06FeAJoiDrlS2KLEE RBKpCxxBkME11DddiBraig_cq8F_I2VBl3.cwYnu8bVVCzOjwbAo_Fa0gImi8sTHxAm9FRgMOJDT 9W4D0h98QPmhTtSkA1sCsUxJnF6hLS_typlWUo4sgzbdX7PowGtMxK960DeKoDadYbSb5NSGNqgX y3WuXOL.AjNQcV6a9k_ishciYdbEoQ0PYYHc0HC_NLlgmvHtzFteIzw7HWObc.OfZy1tph.mEhib en8yQil.ScuIfefyNTJZNlbyNINxtQXPZ9A9OV53uT.lXulB5GPIRGA3e4ZGP6tq5pMm9vkL0oaO DTr7Bokwvse5SbCWD_VlUUYlcvPpgyOAFqyF_emStCAIMFvHZDqhl8uPa6J7uOAsw0CE8J3HlYW_ Sg2Dlhq0ilA3LU3X_IaSDu9u2ZoNT0KJ6xJCRBnRqCzPbju3WPa4IFYfYWkpuHW4sSqRsMjeXb8N QjnWsu7FVbb9o_D3MuPbc0oUVaiYfmkZq8b_9BSfczT855duDaaT.uIcZFLx6kkCjLtXHqkbyhCN w8VTwv38O0C9d0M6VZk_itSf522rzWQlv65_UFAnFl7tvSi.gRqqWX3t.CeU6wI940afxXVtR2Do zQoRpIK82yICB810itbuQP2YuNCi90w6ctOMTXwHsKCbz7r8SDBwDCC3oy5S8puNaZn3xw1OTjWY Et5wcThCjBo_lAcQBxPqi2d6K7yniaQzkzNqcgj9wk3VVUSn2FS4ISDbe6ILeMNtysuSJxLUmpIc WsUOrsqSbCcqZJFSzn7TO561ennXSnhZj9ttXU4GwWr3cvCQq3MIvfUQ72sW5LFn0fcU.oXFXaCC 3z21ku0WHhAdIGCLCXeYzNGIqxRhdggbGQdjQIwx98PkdgAQO1qqw0vxCRl1RQX9YjO4Jyg15_Hm ZVZggL0Xwc15E1wNin4p8L3mWnpbdKhEByIGe_9PENYsvFqI98dL7YY8LUhFAD80qJgtWeV1RMN5 JlkPaQjNicTyj5_vcN38t9pYVUwPFH5uirgPWCyj_B7pe9A-- X-Sonic-MF: X-Sonic-ID: 54c3a036-8a43-4e55-982b-bc9d29a2aa0d Received: from sonic.gate.mail.ne1.yahoo.com by sonic313.consmr.mail.ne1.yahoo.com with HTTP; Wed, 10 May 2023 21:01:23 +0000 Date: Wed, 10 May 2023 21:01:18 +0000 (UTC) From: James Fraley Reply-To: James Fraley To: "pgsql-admin@lists.postgresql.org" , Matthew Planchard Message-ID: <1003715664.279699.1683752478378@mail.yahoo.com> In-Reply-To: <87ild0p6d4.fsf@gmail.com> References: <87ild0p6d4.fsf@gmail.com> Subject: Re: Index recreation details with REINDEX TABLE CONCURRENTLY MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Mailer: WebService/1.1.21471 YMailNorrin Content-Length: 885 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk How do I get off this list? Respectfully, James Fraley Anima Sana in Corpore Sano On Wednesday, May 10, 2023 at 01:59:37 PM EDT, Matthew Planchard wrote: Hello, We're working on setting up some regular jobs to reindex tables where we wind up generating a lot of index bloat. We're planning on using REINDEX ... CONCURRENTLY. We'd like to reindex all of the indexes on the tables. In some of our environments, these tables are very large and under high load, and we want to minimize the resource consumption of index recreation if possible. With that in mind, my question is: does REINDEX TABLE CONCURRENTLY operate on the indexes of the table in parallel, or sequentially? If in parallel, I imagine we would see less DB resource utilization by updating one index at a time. Thanks in advance for any help you can provide. Best, Matthew