Re: Does the delete+insert is fater and less cpu consumer than update?

From: legrand legrand <legrand_legrand(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Does the delete+insert is fater and less cpu consumer than update?
Date: 2017-12-14 23:08:32
Message-ID: 1513292912581-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

If you use partitioned tables,
and just want to reload data from some partitions

you can then use the truncate partition syntax
or develop a procedure like described here

https://www.postgresql.org/message-id/AM4PR03MB171327323DCD2069A532756190850@AM4PR03MB1713.eurprd03.prod.outlook.com

Regards
PAscal

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Venkata B Nagothi 2017-12-15 02:20:52 Re: Can postgresql ignore DST ?
Previous Message David G. Johnston 2017-12-14 22:44:12 Re: Does the delete+insert is fater and less cpu consumer than update?