| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | Alexander Pyhalov <alp(at)rsu(dot)ru> |
| Cc: | Magnus Hagander <magnus(at)hagander(dot)net>, pgsql-general General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: duplicate primary key |
| Date: | 2017-11-25 04:43:51 |
| Message-ID: | CAB7nPqTT4YW5h0cfbWGz=K_YPGH5NmDe2jvQG6kTU1gdr1W_yA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Nov 23, 2017 at 1:28 AM, Alexander Pyhalov <alp(at)rsu(dot)ru> wrote:
> On 11/22/17 07:24 PM, Magnus Hagander wrote:
>> What is your postgres version, and what's the "version history" of
>> upgrades
>> from it (talking pg_upgrade upgrades, not dump/reload upgrades). This
>> might
>> be fallout from old bugs thaat have been known to cause this type of
>> problem.
>>
>
> It's PostgreSQL 9.5.10 (64bit), running on Ubuntu 16.04.
> Last major update was done as full dump/restore.
You may as well be facing what is called the freeze-the-dead bug,
where a VACUUM FREEZE brings back dead tuples:
https://www.postgresql.org/message-id/E5711E62-8FDF-4DCA-A888-C200BF6B5742@amazon.com
There is a patch in the works for it that should land in the next
round of minor releases.
--
Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adam Tauno Williams | 2017-11-25 15:01:43 | Re: How clear the cache on postgresql? |
| Previous Message | Jeff Janes | 2017-11-25 03:49:55 | Re: How clear the cache on postgresql? |