Alexander:
On Sun, Apr 2, 2017 at 5:27 PM, Alexander Farber
<alexander.farber@gmail.com> 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.