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 1rwBmt-00HTxz-98 for pgsql-general@arkaria.postgresql.org; Mon, 15 Apr 2024 02:09:39 +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 1rwBmr-009q8V-SK for pgsql-general@arkaria.postgresql.org; Mon, 15 Apr 2024 02:09:37 +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 1rwBmr-009q7M-Go for pgsql-general@lists.postgresql.org; Mon, 15 Apr 2024 02:09:37 +0000 Received: from mail-oa1-x2f.google.com ([2001:4860:4864:20::2f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rwBmp-000zHP-62 for pgsql-general@lists.postgresql.org; Mon, 15 Apr 2024 02:09:36 +0000 Received: by mail-oa1-x2f.google.com with SMTP id 586e51a60fabf-23333ef4a02so2024537fac.1 for ; Sun, 14 Apr 2024 19:09:34 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1713146973; x=1713751773; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=tHYUqGPOnrSdSjJufUGDaWZEUhF/U8k3IZNf8qewzOI=; b=fMDTQDK8IFdAMrjg4liUAA3rxdg4hyeZzdvPNUxpwwvDz5Tkz86sAqtMDIw92PqmNZ 9y+evPjKC/eb1kIqaEB+SZYEw53X3eo5kJDk8A2p0adRPTQJ/ZvOyiqf4J/eKQmF/+1Q zYgcBnwNLlWGYoUcFYugByP0X0ZMrbVlN9uLtkvsUpAEsIlWcaxbFme195AKYIFrr9C5 vU2JnXhnv8iFHj/qh0bmD3CkTxfJlwuA+K0m71y3qjsG2YimNCusH5u2Pq7DwHuS/wGi dOa7mBCxGfo+IMJJ2N4jB4QE/f1QUUlal4i7e0biIq2uEwpH+E6UpC+M6IMd3u3DaffL 4odQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1713146973; x=1713751773; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=tHYUqGPOnrSdSjJufUGDaWZEUhF/U8k3IZNf8qewzOI=; b=CkvHg4hUkhesoKzJkz2HctP+2UghRK6kUusmfkOK18d3rnYHrMsx1PeXZ5RPL/eLx4 xedpk8vE2fjbKF8sW1g2YZT/nAqPFpS1DPRjpNZtXwggD0pWwJzlwDe7x6xZNDAi449k 7DC72Y8JhHdGoz/4d3Yooj4yJqyTXbdxPltGhHUjHtX+0e1gRBsyOL6VZt9u46MDJMAA YICLKuPT8wcUGfatVfQ1PWYecFdN2aJNLLNyl/XOk5l1Yxdny70IzvE21chL3ArlLFFW +9cX0yJwjLWChoLu3yv4j9gI5go4RW0Qe7CIp9jXWGV9BBSmsxjQx1WCDtVjFUH1Ppqc SipA== X-Forwarded-Encrypted: i=1; AJvYcCU5pwN3q2NBJL3/sae3ij8GRLlrXijeFNwmW2Rrmvr5zQ+FL+jEFwAYtQbTj6vzNSyDYDAlw3hiDcYmFMn0qcvdu/BEvwWnXiEtO1+esBthB7NA X-Gm-Message-State: AOJu0YzF1VqabPrFoVRCZa7XwFw4z6XgHEz9QRAD96hkGpyXZMkYndve xYfWbmD+CyTWuOMVVoBjsrUL+WmM5g1LF6vYjbCSDPhY/5S/9VhPRct64nzYuftylYFQwGT5bb0 9GYf4LiV7x/KmFk9gZ6/C1U26KOvMWA== X-Google-Smtp-Source: AGHT+IHwnjr83jLcqkCO5KoR9JaXZJM2qKt05mTF1bHV8HYBjUC3axumdjL07TOCQjzKkhZf0LR8RVsw4w5neoSS7Ig= X-Received: by 2002:a05:6870:a449:b0:22e:9a3a:14c3 with SMTP id n9-20020a056870a44900b0022e9a3a14c3mr11036920oal.17.1713146972973; Sun, 14 Apr 2024 19:09:32 -0700 (PDT) MIME-Version: 1.0 References: <311b047d-01f1-4ce3-86de-09ff0181ba00@aklaver.com> <22563b64-de45-4131-b6b1-8498abb6c718@aklaver.com> In-Reply-To: From: "David G. Johnston" Date: Sun, 14 Apr 2024 19:08:56 -0700 Message-ID: Subject: Re: constant crashing To: jack Cc: Adrian Klaver , "pgsql-general@lists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000c5b0ff0616191c71" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000c5b0ff0616191c71 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Sun, Apr 14, 2024 at 6:58=E2=80=AFPM jack wrote: > But the current i9 machine is a machine from only 4 years ago which shoul= d > have no issues. > > That is a non sequitur. Besides, if the current code is a representative example you've probably given it the effective usage of 8 years. Whether related or not to this error you really should be doing all those updates on a temporary or unlogged staging table and getting WAL generation out of the equation. David J. --000000000000c5b0ff0616191c71 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Sun, Apr 14, 2024 at 6:58=E2=80=AFPM jack <jack4pg@a7q.com> wrote:
=
But the current i9 machine is a machine from only 4 years ago which= should have no issues.


That is a non= sequitur.=C2=A0 Besides, if the current code is a representative example y= ou've probably given it the effective usage of 8 years.

Whether related or not to this error you really should be doing all t= hose updates on a temporary or unlogged staging table and getting WAL gener= ation out of the equation.

David J.
--000000000000c5b0ff0616191c71--