| 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: | Whole Thread | Raw Message | 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 |