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.96) (envelope-from ) id 1vkmZ4-0023Z9-0L for pgsql-admin@arkaria.postgresql.org; Tue, 27 Jan 2026 17:09:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vkmZ2-00F2a0-2w for pgsql-admin@arkaria.postgresql.org; Tue, 27 Jan 2026 17:09:17 +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.96) (envelope-from ) id 1vkmZ2-00F2Zs-1g for pgsql-admin@lists.postgresql.org; Tue, 27 Jan 2026 17:09:16 +0000 Received: from mail-wm1-x342.google.com ([2a00:1450:4864:20::342]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vkmZ0-00000000jpb-1rjl for pgsql-admin@lists.postgresql.org; Tue, 27 Jan 2026 17:09:16 +0000 Received: by mail-wm1-x342.google.com with SMTP id 5b1f17b1804b1-47ee0291921so51211845e9.3 for ; Tue, 27 Jan 2026 09:09:14 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1769533753; x=1770138553; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=wLvScBJZVcnfPReidQaUvso8HKPdQqiqdM/bvTmoqDc=; b=lF1NY3Omiv4SOW2UQGjnMd+/eXLLJSmRZRJxfVWOIJXs0q5UtJxTd6UJGuCS/QGWs6 EEO5QyGLKkX3GLgTb3wDLW724TgpmZYHcY8peqw9iJQOj2PhphRrBNjWVd34SDpFH+Jp cQCuE7ZTRx7SHO4rF8K4ApLC7eVipyZyIpz7ikaxOKAoOyRmPDJlaaLsjSVzTujjDI2j 1De24WLewYubJUZZnK8HNaXfn+BGj2f0VvzVcyYen33cywbItcAePHQKtRjr1x2mYfqc Jf25D1F8S8d4Lfo1TXfpCpREorJbErkVFhh0LYTWFLdUwcRXzmNC+Zvj9zRfHwmVYrGk 8mCw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1769533753; x=1770138553; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=wLvScBJZVcnfPReidQaUvso8HKPdQqiqdM/bvTmoqDc=; b=DQOA1zb1SfRe6qEssah6G1Iyrqi7Jyfi4D84HMWhtI/2D0i3mLfpw02TfoFRr91vnW enLLOTMlZoZ/+he+vWajFZnge4kZsckT4UNrhzzHsAeoovWu0/4Wl3ZtHmWEh+XSgNVw VPMOuhajrwujX/0UpJbYnCeN+bRq3ixB42QZWKBTSzvdjRrk9B78wm48fDX1lN3K02RK t3XpdGFq8wN4gBo/Eg7PDI8tbpVPHTnwTl7c8+Y9i5rFRxz7tO6Q13hvtM+yPappnehK LHeDtZwVrofxhuN/BKtmen125Q8VJEoxtiSh6nrfUnqyZkRjhZzfq1IWZ7hS9xQj4CLY QhtA== X-Forwarded-Encrypted: i=1; AJvYcCXlBuAhkE+yD9edIJjtWajaMYydjo9HE80s/TF0k1QcDhaegtHuGwOX7nhsrUOklOarI7x8iL7fgWn9ew==@lists.postgresql.org X-Gm-Message-State: AOJu0YyLGIFCT4RE4zj+vU5fZvI9KPS/u5vbj0ddy31Ej9bRZRmuFaR8 FpkW0sRWMbVtxN7dgcTWsToQP5k6x9rxAvFs8OFE5w6ESZA7mJEJLl9GSbJAy1bmmLo= X-Gm-Gg: AZuq6aIVIt0n2mSKg+XDRjaFwqcZcohVZE1Pe5wbJux23SNDGFNb2OVZLpgJsF1X8IZ /XjgcPMUuskhPoS4PMMVDXlcPhBmAorUhTP2zKp3679aDKbqM+/VeUmZQV8+JKXJjhkC/Up/+Zu PYXp5KnqWUDKV7W44aKI0iJQSi6ly5xFY0BrKt092OWuBwaUNtfZ3BDW0jaE6j38dmbiuAXiBVQ Ds5EGSqXJZyRiDb8MYN1vqAsUpRa+mBZSdMVI1eYPr481ePiXs5uZfO8N0klWhRl1o/hx7vVsfV krekHGVU1kHNW8XOWNj9T4N7kkOS4TrAZVn4gFMiMb/JfMt9yWRNjZT+YNKvYtIS16xwTz0iv3C wJCqzPSLg3bbhFat2KgVE4FejBBGhtljLVpaYtOZPAtal9YHRyqoYM5R4jeKY+G9oI546JEz65i 4ubvqMJ1RRQ3TZ8IzPnwsA69khA4QDWmOzR9N/xhii1eSuji8kg8BzBWxR29jXh4Pudyziq6lll SGdu+DBLWClWlYsusH8PN5QjfR0ubQD X-Received: by 2002:a05:600c:64ce:b0:45c:4470:271c with SMTP id 5b1f17b1804b1-48069c8c59dmr29851575e9.18.1769533753218; Tue, 27 Jan 2026 09:09:13 -0800 (PST) Received: from laurenz.albe-K4N0CV00F97414D (210.144.128.164.static.wline.lns.ent.cust.swisscom.ch. [164.128.144.210]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-435e131ce64sm109522f8f.26.2026.01.27.09.09.12 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 27 Jan 2026 09:09:12 -0800 (PST) Message-ID: <80206a0ce9fccc0515c9d8f60a038a04cc37e65c.camel@cybertec.at> Subject: Re: autoanalyze did not run From: Laurenz Albe To: Kristjan Mustkivi , Pgsql-admin Date: Tue, 27 Jan 2026 18:09:12 +0100 In-Reply-To: References: <0dce35ca-24fa-4234-99fe-071bd5725a32@ya.ru> <04dc073cd84313cb9b711833f905a07d099a5f28.camel@cybertec.at> <99731769513229@mail.yandex.ru> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.58.2 (3.58.2-1.fc43) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 2026-01-27 at 14:10 +0200, Kristjan Mustkivi wrote: > I do apologize if I mix something up now, but I would expect COPY to > have an effect on "n_ins_since_vacuum" but not "n_mod_since_analyze". > COPY inserts rows, it does not update them. Rows added by COPY must definitely count for "n_mod_since_analyze". Yours, Laurenz Albe