Postgres Pro
Downloads
Home   >   mailing lists

Re: Does the delete+insert is fater and less cpu consumer thanupdate? - Mailing list pgsql-general

From legrand legrand
Subject Re: Does the delete+insert is fater and less cpu consumer thanupdate?
Date
Msg-id 1513292912581-0.post@n3.nabble.com
Whole thread Raw
In response to Re: Does the delete+insert is fater and less cpu consumer than update?  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Does the delete+insert is fater and less cpu consumer than update?
Next
From: Venkata B Nagothi
Date:
Subject: Re: Can postgresql ignore DST ?