From: | Francisco Olarte <folarte(at)peoplecall(dot)com> |
---|---|
To: | Alexander Farber <alexander(dot)farber(at)gmail(dot)com> |
Cc: | Andy Colson <andy(at)squeakycode(dot)net>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Merging records in a table with 2-columns primary key |
Date: | 2017-04-02 15:41:14 |
Message-ID: | CA+bJJbycKKpuFUWBkD5th9Rq7LBragtEuB4KE0yAH6VZ8m2fkw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Alexander:
On Sun, Apr 2, 2017 at 5:27 PM, Alexander Farber
<alexander(dot)farber(at)gmail(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Patrick B | 2017-04-03 01:23:34 | effective_cache_size X shared_buffer |
Previous Message | Francisco Olarte | 2017-04-02 15:37:36 | Re: Merging records in a table with 2-columns primary key |