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 1mxACY-0002J6-Ie for pgsql-general@arkaria.postgresql.org; Tue, 14 Dec 2021 15:58:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mxACW-0006l0-Fg for pgsql-general@arkaria.postgresql.org; Tue, 14 Dec 2021 15:58:48 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mxACW-0006ko-5C for pgsql-general@lists.postgresql.org; Tue, 14 Dec 2021 15:58:48 +0000 Received: from smtp10.smtpout.orange.fr ([80.12.242.132] helo=smtp.smtpout.orange.fr) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mxACO-0008HL-8l for pgsql-general@lists.postgresql.org; Tue, 14 Dec 2021 15:58:46 +0000 Received: from X201.home ([81.251.245.227]) by smtp.orange.fr with SMTP id xACKmSLUBV2Y1xACKmTXpi; Tue, 14 Dec 2021 16:58:37 +0100 X-ME-Helo: X201.home X-ME-Date: Tue, 14 Dec 2021 16:58:37 +0100 X-ME-IP: 81.251.245.227 Date: Tue, 14 Dec 2021 16:58:35 +0100 From: Vincent Veyron To: Klaudie Willis Cc: "pgsql-general@lists.postgresql.org" Subject: Re: When Update balloons memory Message-Id: <20211214165835.10070d2bc2a893a7e560e6bb@wanadoo.fr> In-Reply-To: References: <3484560.1638889073@sss.pgh.pa.us> <189763.1639437451@sss.pgh.pa.us> X-Mailer: Sylpheed 3.7.0 (GTK+ 2.24.32; i686-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 14 Dec 2021 08:16:08 +0000 Klaudie Willis wrote: > CREATE INDEX partindx ON public.part_main USING btree ((actiondate)::date= ); -- mem bug? Nope, syntax error ERROR: syntax error at or near "::" LINE 1: ...indx_1 ON public.part_main USING btree ((actiondate)::date); ^ > -- CREATE INDEX partindx ON public.part_main USING btree (actiondate); --= no bug > -- mem runaway follows > update part_main set txid =3D txid + 1; >=20 > Hope you can replicate it. >=20 Can't replicate on my Intel(R) Core(TM) i5 CPU M 520 @ 2.40GHz with 2Go of= RAM time psql -c 'update part_main set txid =3D txid + 1' vv UPDATE 31000000 real 24m39.594s user 0m0.121s sys 0m0.036s --=20 Bien =E0 vous, Vincent Veyron https://marica.fr Gestion des contentieux juridiques, des contrats et des sinistres d'assuran= ce