| From: | Vincent Veyron <vv(dot)lists(at)wanadoo(dot)fr> |
|---|---|
| To: | Klaudie Willis <Klaudie(dot)Willis(at)protonmail(dot)com> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: When Update balloons memory |
| Date: | 2021-12-14 15:58:35 |
| Message-ID: | 20211214165835.10070d2bc2a893a7e560e6bb@wanadoo.fr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-general |
On Tue, 14 Dec 2021 08:16:08 +0000
Klaudie Willis <Klaudie(dot)Willis(at)protonmail(dot)com> 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 = txid + 1;
>
> Hope you can replicate it.
>
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 = txid + 1' vv
UPDATE 31000000
real 24m39.594s
user 0m0.121s
sys 0m0.036s
--
Bien à vous, Vincent Veyron
https://marica.fr
Gestion des contentieux juridiques, des contrats et des sinistres d'assurance
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2021-12-14 15:58:55 | Re: When Update balloons memory |
| Previous Message | Dmitry Dolgov | 2021-12-14 15:46:04 | Re: BUG #17326: Postgres crashed when pg_reload_conf() with ssl certificate parameters |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2021-12-14 15:58:55 | Re: When Update balloons memory |
| Previous Message | Adrian Klaver | 2021-12-14 15:50:25 | Re: timestamp default current_timestamp not working |