Horton

Re: ANALYZE: ERROR: tuple already updated by self

Tomas Vondra <tomas.vondra@2ndquadrant.com>

View thread View on postgr.es
From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
To: Andres Freund <andres@anarazel.de>
Cc: Justin Pryzby <pryzby@telsasoft.com>, Tomas Vondra <tv@fuzzy.cz>, Dean Rasheed <dean.a.rasheed@gmail.com>, pgsql-hackers@postgresql.org
Date: 2019-07-29T10:18:33Z
Lists: pgsql-hackers 
On Sun, Jul 28, 2019 at 09:53:20PM -0700, Andres Freund wrote:
>Hi,
>
>On 2019-07-28 21:21:51 +0200, Tomas Vondra wrote:
>> AFAICS it applies to 10+ versions, because that's where extended stats
>> were introduced. We certainly can't mess with catalogs there, so this is
>> about the only backpatchable fix I can think of.
>
>AFAIU the inh version wouldn't be used anyway, and this has never
>worked. So I think it's imo fine to fix it that way for < master. For
>master we should have something better, even if perhaps not immediately.
>

Agreed. I'll get the simple fix committed soon, and put a TODO on my
list for pg13.


thanks

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Commits

  1. Don't build extended statistics on inheritance trees