From: | Jan Wieck <jan(at)wi3ck(dot)info> |
---|---|
To: | Perry Smith <pedz(at)easesoftware(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Help with large delete |
Date: | 2022-04-16 17:57:11 |
Message-ID: | CAGBW59cU8suXObwMjt4w9CzPnJnY8nLvZyweQqiSH+MP82k4Aw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Make your connection immune to disconnects by using something like the
screen utility.
Regards, Jan
On Sat, Apr 16, 2022, 09:26 Perry Smith <pedz(at)easesoftware(dot)com> wrote:
> Currently I have one table that mimics a file system. Each entry has a
> parent_id and a base name where parent_id is an id in the table that must
> exist in the table or be null with cascade on delete.
>
> I’ve started a delete of a root entry with about 300,000 descendants. The
> table currently has about 22M entries and I’m adding about 1600 entries per
> minute still. Eventually there will not be massive amounts of entries
> being added and the table will be mostly static.
>
> I started the delete before from a terminal that got detached. So I
> killed that process and started it up again from a terminal less likely to
> get detached.˘
>
> My question is basically how can I make life easier for Postgres? I
> believe (hope) the deletes will be few and far between but they will happen
> from time to time. In this case, Dropbox — its a long story that isn’t
> really pertinent. The point is that @#$% happens.
>
> “What can I do” includes starting completely over if necessary. I’ve only
> got about a week invested in this and its just machine time at zero cost.
> I could stop the other processes that are adding entries and let the delete
> finish if that would help. etc.
>
> Thank you for your time,
> Perry
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Perry Smith | 2022-04-16 18:24:07 | Re: Help with large delete |
Previous Message | Tom Lane | 2022-04-16 17:15:33 | Re: ***SPAM*** Re: Help with large delete |