Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qeVp6-006ykt-Em for pgsql-general@arkaria.postgresql.org; Fri, 08 Sep 2023 07:22:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qeVp5-008Rlb-87 for pgsql-general@arkaria.postgresql.org; Fri, 08 Sep 2023 07:22:35 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qeVp4-008RlL-Sl for pgsql-general@lists.postgresql.org; Fri, 08 Sep 2023 07:22:34 +0000 Received: from mail-wm1-x332.google.com ([2a00:1450:4864:20::332]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qeVp1-003pYE-Aa for pgsql-general@lists.postgresql.org; Fri, 08 Sep 2023 07:22:34 +0000 Received: by mail-wm1-x332.google.com with SMTP id 5b1f17b1804b1-401b393ddd2so19856175e9.0 for ; Fri, 08 Sep 2023 00:22:31 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1694157750; x=1694762550; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:reply-to:from:subject:message-id:from:to:cc :subject:date:message-id:reply-to; bh=dcjPCi1MJ4q0J1qQN4cGDsvtISrpOX/1F5vpzm/74Rw=; b=q0z9iv98UIM0DwIxJKHOf7eWCusD6BxATJb4/mqjIr8b3ZT9U1dNYqgMV279+8rPaS aid96vnpgLOzPJKhq1IRRp/X1E4pJHOISf/GK89ihe/a11hGMKzk0txdIt15gffpDoOe fWnYXLsuL7VK6sHvRGhTLlbL1lONSni+GDIPu5WoAvT6DcafGA4UxZcyHMMXRP3IUH/s +c9SXOexU1T0F8Ri3qmpzkLSodQWdGibAuBy+ZMK6rrD4EduCoQCDHyC4tGxrOLr6Bkj WVZB4qGKUIztEFdFhuD/Mi8GBgIq5g0pjcra8GEeiVgAsfKPzbrAYssrRj7hOVAcyYJw RMwA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1694157750; x=1694762550; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:reply-to:from:subject:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=dcjPCi1MJ4q0J1qQN4cGDsvtISrpOX/1F5vpzm/74Rw=; b=CE7Bm8qdnm/jj41DvAn87O4n+JBkYwFMFVOzBeD6Cvs7uL2uMZNgwkBD3CuBJObLvR 4VDZ+1whWH/FYcONxpQCH9UDJs9iAtYTETjeewuWLWi2QJKRRFzWAVZtmujWYkRgGe8i vh4eIlWRzqhyXwTRe5kWwDyKunS4bTHROiYC2MxueX0c8qDKJ3VBcmFOos/1kHoA9m+R uRL2eoG5JdjovSU79CmNdupaKC0mdMIAFQwRolf7wUccJiZl6Gzaapwj8eCoX6JVsIRh e8jiYVtR2fXo65KvcLMPCO5xnmT4Eu5dn4bJJLEWTZ3sP2tO9IoqWE4+Owm6/dAol3uR mC7g== X-Gm-Message-State: AOJu0YytYqrm8Ol8TuJVQ1VeUBNpcm9HHUx/Whr/B9QyI+2HygRpzdh9 PWPFvh9RoYIEHSHHXix2kcBnJx/tTMI= X-Google-Smtp-Source: AGHT+IFGo7NGAj7a3wpEbyd+l7JB13NaQIOxjXc8xlDEXA3MMvvksjGLWuqMUx7Ad7xi2Mu0JXwyIA== X-Received: by 2002:a7b:cd97:0:b0:401:c52c:5ed9 with SMTP id y23-20020a7bcd97000000b00401c52c5ed9mr1316487wmj.32.1694157749969; Fri, 08 Sep 2023 00:22:29 -0700 (PDT) Received: from TORSTENKNBL2.fritz.box ([2a02:810a:14bf:d7a4:fde2:755b:1459:a2ef]) by smtp.gmail.com with ESMTPSA id y10-20020a05600c364a00b00401b242e2e6sm4417880wmq.47.2023.09.08.00.22.29 for (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 08 Sep 2023 00:22:29 -0700 (PDT) Message-ID: <98bf0c47840ebb806808223102d3c78192800c26.camel@gmail.com> Subject: Re: running ANALYZE results in => duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index" From: Torsten Krah Reply-To: krah.tm@gmail.com To: pgsql-general@lists.postgresql.org Date: Fri, 08 Sep 2023 09:22:29 +0200 In-Reply-To: References: <959e9b03415d2ac683d67059f74d0377f64b03f4.camel@gmail.com> <914c8b13fe9c1fb41a3b673b59813a210c72c92f.camel@cybertec.at> <8af28a305839719a496be84d18c15a2525e954c8.camel@gmail.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.44.4-0ubuntu2 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Am Mittwoch, dem 06.09.2023 um 20:42 +0200 schrieb Imre Samu: > Maybe you have to increase the "*--stop-timeout" value=20 That is totally unrelated in my case, it is an anonymous volume anyway which gets created on start and deleted afterwards. Torsten