From: Tom Lane <tgl@sss.pgh.pa.us>
To: jack <jack4pg@a7q.com>
cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Re: constant crashing
In-reply-to: <EOK1DtQPZjUx8lfmH2mKBjPejveLIfJ8M_GR-At5A9yhT-Ki5JE9GyvQ657CQZWOmZu3OsByefHlGymD3i60c-eYE7uiSYQDVZsujA3fZZA=@a7q.com>
References: <EOK1DtQPZjUx8lfmH2mKBjPejveLIfJ8M_GR-At5A9yhT-Ki5JE9GyvQ657CQZWOmZu3OsByefHlGymD3i60c-eYE7uiSYQDVZsujA3fZZA=@a7q.com>
Comments: In-reply-to jack <jack4pg@a7q.com>
	message dated "Sun, 14 Apr 2024 14:24:44 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <412542.1713107157.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Sun, 14 Apr 2024 11:05:57 -0400
Message-ID: <412543.1713107157@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/412543.1713107157%40sss.pgh.pa.us>
Precedence: bulk

jack <jack4pg@a7q.com> writes:
> I am trying to load about 1.4 billion records into a postgresql table.
> The data is in about 100 individual CSV files which I load individually =
into the table using the COPY command.
> After the data is loaded I perform updates to the data, and this is when=
 I get errors. Some updates work, some crash.
> I am using psql and an SQL script file (update.sql) to perform the updat=
ing (UPDATE table SET field=3DUPPER(field), etc.).

> The errors are all "Server closed the connection unexpectedly"

What appears in the postmaster log when this happens?

It would also be instructive to run "top" while you trigger
the problem, and see if there is obvious distress like the
server process's memory consumption ballooning.

It smells like a resource-exhaustion problem.  Which probably
shouldn't be happening on a machine with 128G RAM, but maybe
something is misconfigured to give up way below that.  In any
case, you'll never find the cause from the client side.

> Last attempts have been with ubuntu 22.04.04 and postgreSQL 16.

16 dot which?

			regards, tom lane