Re: PostgreSQL “tuple already updated by self”

2018-05-22 Thread Michael Paquier
On Tue, May 22, 2018 at 09:17:15AM -0400, Robert Haas wrote: > Another interesting question is how the system got into this state in > the first place, of course. Was it a bug, or did you do something > that corrupted the database? Perhaps a side effect which has been fixed in d2599ecf for 9.6.9?

Re: PostgreSQL “tuple already updated by self”

2018-05-22 Thread Robert Haas
On Tue, May 22, 2018 at 8:01 AM, SG wrote: > Our database seems to be broken, normally it uses about 1-2% of cpu, but if > we run some additional backend services making UPDATE and INSERT queries for > 10M rows table (about 1 query per 3 second) everything is going to hell > (including CPU increas

PostgreSQL “tuple already updated by self”

2018-05-22 Thread SG
NALYZE on ANY of the tables and could not find any information about this issue. Any suggestions what can be wrong? PostgreSQL 9.6.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-16), 64-bit Stackoverflow thread: https://stackoverflow.com/questions/50450162/pos