Alexander: On Sun, Apr 2, 2017 at 5:27 PM, Alexander Farber <alexander.farber@xxxxxxxxx> wrote: > 2) Is there a way to use an UPDATE reviews instead of the inefficient > (because copying) INSERT ... SELECT ... ON CONFLICT DO NOTHING? mmm, I've just sent a sugestion to use delete+reinsert and would like to point that in pg update~=delete+insert. I use those because many times they are more efficient ( simple conditions on delete, insert is fast in postgres, and you can vacuum in the middle if a large portion is going to get reinserted to reuse the space ) Francisco Olarte. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
