public inbox for [email protected]
help / color / mirror / Atom feedFrom: jack <[email protected]>
To: [email protected] <[email protected]>
Subject: re: constant crashing
Date: Sun, 14 Apr 2024 16:20:07 +0000
Message-ID: <HgsD3gOH-K3PK0n7PogBu3X1goIJ3_kN04shv7womj--6jQcAggYWdAOqYOmq1VVlVPf6TiHvxpZCvwmFawmHMEjciHsLErgsjaLruEspg0=@a7q.com> (raw)
The full error reads:
server closed the connection expectantly
This probably means the server terminated abnormally
before or while processing the request.
error: connection to server was lost
PostgreSQL 16.2
I also believe it is a resource issue which can be rectified with a setting, but which setting?
If you were updating 100 million records what settings would you adjust?
Here are the updates I am performing on the 100 million records:
UPDATE table SET category_modified = UPPER(category);
UPDATE table SET category_modified = REGEXP_REPLACE(REPLACE(REPLACE(category_modified, '''','-'), '`', '-'), '\s{2,}', ' ', 'g') WHERE AND LENGTH(category_modified)>1 AND POSITION('--' IN category_modified)>0;
UPDATE table SET category_modified = REPLACE(category_modified,' ','-');
UPDATE table SET category_modified = CASE WHEN category_modified IS NOT NULL THEN regexp_replace(category_modified, '[^a-zA-Z]$', '') ELSE NULL END;
UPDATE table SET category_modified = regexp_replace(category_modified, '-{2,}', '-', 'g');
UPDATE table SET category_modified = SUBSTRING(category_modified FROM 1 FOR LENGTH(category_modified) - 1) WHERE LENGTH(category_modified)>1 AND category_modified LIKE '%-';
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: re: constant crashing
In-Reply-To: <HgsD3gOH-K3PK0n7PogBu3X1goIJ3_kN04shv7womj--6jQcAggYWdAOqYOmq1VVlVPf6TiHvxpZCvwmFawmHMEjciHsLErgsjaLruEspg0=@a7q.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox