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 1lwLLQ-00037J-UC for pgsql-admin@arkaria.postgresql.org; Thu, 24 Jun 2021 09:08:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lwLLP-0002aW-U7 for pgsql-admin@arkaria.postgresql.org; Thu, 24 Jun 2021 09:08:19 +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 1lwLLP-0002aO-Bm for pgsql-admin@lists.postgresql.org; Thu, 24 Jun 2021 09:08:19 +0000 Received: from sonic311-20.consmr.mail.sg3.yahoo.com ([106.10.244.37]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lwLLM-0002Mz-Uu for pgsql-admin@lists.postgresql.org; Thu, 24 Jun 2021 09:08:19 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1624525691; bh=oP98nNoL9bi1dg8ayPdHXaQLPVH+sZ+N6fdPa+mtIgk=; h=Date:From:To:Subject:References:From:Subject:Reply-To; b=RRIDF3ZtxxKymcJWqQNjC3KLoMDtWBfFW8hGtawfKWtMwgO7YWDeJSe0t6le98gDGvfufufHX5X0aJpTERfOarXO0w0VnZBPFT11jxj7CcWexJ8+o88TU5sTeTsYcOD9n+HTXTF4+euIhpE2NuAP7t3HPmweaYnZDjoW9abSl9FG5HbeV2bXICS5tYDaG8deoEc8Pg6cBqO/hK4B1BlIj0pcy7pj5Ze38hs1ATs0I3N3FSXU+Lo1RirytWiSMg7g+EzUH6GL+5ktLqhST2weD74fEe9Fqxl5g2z3x1/9faT9cqAi3OToN8/VhOKtoFyBOf57QpwQ23JB24hOktf15w== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1624525691; bh=mqTmZATjJ16HMZBz49tBXxXq2V2nXqWP0fRW2MfHx4V=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=qatfdBkIHu4WFIr7UFQfld4zKnKROuSE6IGXdM5vLCBqxVrbDfTkrXXySRsCsRA7jPlYkxDqXKgjaQO7/3d/a4LmAat27pVss2dzIVHi8GBWXjiZ5FJzaz5lKGMIsK5uIc7bGDGCETtoPvPz4/1PQTfosq9sVhGnIgNJ5o3YgbIybn2OlWJsliybllagHNdgTYD1y5y9R3Klshr/ZxU+wC0axqOOQkw3YJkL6q/N36wvrNKqBymLNyBZ78R2XZJ33l/EWI8A25gzfrGnlcbnK0H/E2s6UR9KdkmRZbZn9yUzUEMY07IEWvvTUhGGQeINP+CBDG8vxvhjGs53f/7AXw== X-YMail-OSG: MEX1K.UVM1kHNuhdduFSXfx6dbV.0ljLEpNshRtCYrWWg.KS18Io2D7Nt3cvjdL hIFiu1EGzsl.cxjL42pjbAyIVCvQBW126VLqLkfDy7scnw02PaFiVSyA8MuGxCWo2YeNwkHYGv.8 C5b3VyNn9mBFPMZ6zZV_QiodfHjVRjeYNyX47pVPpXB_eNasMEHaj4qU2PdMqtzCqahZ.J8B_JX8 Mz_6k.UVFjD5vaJ2EgjfPGgYoPURWry8PCv0uBsHW57mKZfE8BW61ErxaRdDD5JjRPnGoTkZTsiP a7fn3aPf.DT2DvglM_dXKGraYNt_gJ6NqhbPzduoMJMoIDOPXSNvZxkv.mp8Bzzmq.1s5BUi1FVa fogrXBlOMxom337cHTqVUi6Rww3UF_0tejo96iVOikspnse9gszD7VcQm22rscwZ.AAqHHaUBM2h C5vJUZtGW_xJd3af6VvgrV1k_110tA_KAGXqWziPdqnzWWwSPIijDz8D3IiJrhlD3IXBTjV9c5Uc 2XtR.itryR6el0cqebXs.JH01ql5Xvy48A6L9FHNlzDEvI4klc9k9tT98Qt4HYHpuCmfQVsrC862 v1RjawHvNpjTSZnpVqcmPWNqus8mO4RldKxXaD6_R5RRIH4IiRd_X7J1BDupM2XkimDv0RPT_zQ4 P46ifax11wqCh4NEKlFKs_zDzBgOI22frizwnx2FWXS4mwwwjIasxXao5rdZidpSStw1_vcdHX0b Sec65.TB14ZOVqtiYHSKqB11S46Od.tZROWZvY_nSJMhIi5wzwQzXhk5r4w8iNC17wGxvUR0knOS .FLATjKZsPaB4TL5gFik8MsWqrFsMkBMmnuJ3AqXHxeRfkcfQALTzWMHD_faUngg_c2Eh8G.bQ6K OOWyFqYhXlh4LBxJAEVawvCcaFAK4SgON9GnjubWPr_fP7q.4D6m0zv9tlk4_xvyC1pXMWyILqGJ gcRnNdJ6tShVck1vdsi6qtLDFQPmHyCwPLPGQhh3PR7C3F6vUpjs1YiBIT8HiF8njV1ZVUAFALLZ YyeY0bsONDlIbsRay4A_qN0e5xxtxcYufpjkBwG.gBYINZfv9c2UIAV5s09Bm6D.Dr_xpkVmzL_w qHiSM1v13J3cC1WlV0gm6Vo4S3cKpEz6TwmHN_0neuR0ag3tmEMFFMz2Ym2lgagznHyNHHGrAKJ7 YoB.EHxOlqCNuXcO7Q7nx7QURjS5BYK1HXsBTNRXZREP6LAH_TAhYRygIeShwpVHZxcbwTFRyPnK CKIoGp6ylf.HGzLqjjCgenngrTv5AlaEvmTySOqbfv3n0r1kU2nsCHavc19jzxy4dfSDGO6K8EiW qWD..KkCBfB5oU5NeJoUtaJ2Gx7StgJpigO4kW_PjDzBJ5RSi.FeqJLo2DKo_lIodhNtJLHjyiMJ O5RdhK2_qKFcasoIDLazPwlTvKHjVuH9It_E_bdAK2Xbm2u5ax0m_vBJYhzZUVZsO5tFYo9NJIH5 H0vp5s7g..fjNn_xZVhD2wmvOVZlcT9ly7WokT1Cz2bCeF2jLW8COOvZ_E75XK6BHYEYkX1EED7w i4TGLArd3YkPVO9kRZpBVI8uUJWlP6sE_6amKaHCKvXy6UiF7yiwZ_8K9HyEJXu5KtEI_AWOZSN4 V_cT5B7FeoeDXyVymJbG_NvNqpYWUe0HqN77JK6E3PbJXnyMinWimwrLsISaPFU4KQSi4ksQMdfZ VdbZGP7cswQ_Qe8Oln1KVyHtHDT8LrL51aD.AHtW2zrk21kO1NZ.di1qYc3gKE6frRumCRc8iFZ2 XJF9CGBlifHfPodvO1nTWmFefN5yMqTvfOjFnjTAg3UPTaq2zfiO1jt_Z0TyMlYx55TwitHxVrbW I0l5oTk5hFT8khNo_fIJ4Fqajfgkl0LdN2E.1agd3tKT3w__k_3061nviw5YgJJLO_Nlk.56vQRo ZqKhMpCkXZ7lkdhWKy8XOuySAqvPnBvzc8GItLJ87qK2LNDEoyOzee53uKDLllA5A1UtnZuSwuGW T.vDogb4sqXyc0L6XEdjpuLKEb5ydEbkjTcAEXPwrheNjzNfcGrN5u8WeHiz1C7x08yX1UsoAapw HlEmplA8EwOh8IUMzfon2o1DE.EAY6tq3fQkyxouJkGOJ.X08_QqLnDy5.3rEU523UqqM0IrV0oB 8enRy4VEw2VjQ4kyEpaLoCPMaTO_l.4N3QIPy0Vs3nKpjh9bY16GClh9X_FwenJxIz22jXJqI6yx HJ5TTYjwjRe4cGNXgLrB6ufVKS1rVHfJ0TNabrg3mMD8p3P.2tnbUjR_n3C.pqx.1qytWGrXQIKP DvvtXj6N9trfumZfGDSbQTFRRwTAFSb7WsujIqnCAcWAn0UBvpPFV69C3C9eDJpoOWEE6k5neXfY w1CxCJOoTF1uLpeZ.HPyoV5lgPUpOfHGSB0.WZ73TjJOImLg_xNagu6EcVlA1uI5ymVUQ7hdArS9 PfHe._MdKHFWm.3LxlubEeGo- X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic311.consmr.mail.sg3.yahoo.com with HTTP; Thu, 24 Jun 2021 09:08:11 +0000 Date: Thu, 24 Jun 2021 09:08:09 +0000 (UTC) From: Rohit Rajput To: "pgsql-admin@lists.postgresql.org" Message-ID: <266147493.2758919.1624525689006@mail.yahoo.com> Subject: Issue with delete MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2758918_642863610.1624525689005" References: <266147493.2758919.1624525689006.ref@mail.yahoo.com> X-Mailer: WebService/1.1.18469 YMailNorrin Content-Length: 2632 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_2758918_642863610.1624525689005 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Good day everyone, I have few tables where i need to delete above 50 million rows each. Since = i dont want to delete them all in one shot and block my table for extended = time, i am trying to use limit with delete but its giving me error every ti= me. May i please get some assistance here? Thanks Here is what i am running: delete from mytable where id in (select id from mytable where condition=3Dt= rue limit 1000); where i run this, i get following error: =C2=A0 =C2=A0 Error: current transaction is aborted, commands ignored until= end of transaction block.SQL state: 25P02. I am running it in RDS. TIA, Best,Rohit ------=_Part_2758918_642863610.1624525689005 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Good day everyone,

I have = few tables where i need to delete above 50 million rows each. Since i dont = want to delete them all in one shot and block my table for extended time, i= am trying to use limit with delete but its giving me error every time. May= i please get some assistance here? Thanks

Here is what i= am running:

delete from mytable where id in (select id f= rom mytable where condition=3Dtrue limit 1000);

where i r= un this, i get following error:

    Error: curr= ent transaction is aborted, commands ignored until end of transaction block= .
SQL state: 25P02.


I am running it in = RDS.


TIA= , Best,
Rohit
------=_Part_2758918_642863610.1624525689005--