Postgres Pro
Downloads
Home   >   mailing lists

Alter table set logged hanging after writing out all WAL - Mailing list pgsql-general

From Jeremy Finzel
Subject Alter table set logged hanging after writing out all WAL
Date
Msg-id CAMa1XUg=9YKo4_VgVNWJZVt7MsKEnui5VnRKL1cyVbJgnmUG9g@mail.gmail.com
Whole thread Raw
Responses Re: Alter table set logged hanging after writing out all WAL  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-general
Tree view
We are running:

PostgreSQL 10.1 on x86_64-pc-linux-gnu, compiled by gcc (Debian 4.7.2-5) 4.7.2, 64-bit

The table I am setting to logged is 32GB with indexes.  I see it writing WAL files like crazy but after about an hour and a half, it has written out some 2500 WAL segments, then it just sits and continues to run as "active", but no more WAL files are being created.  There are no locks, and no other transactions in the system running.

Any ideas?  Is it still doing something that I need to wait for?

Thanks,
Jeremy

pgsql-general by date:

Previous
From: Francisco Olarte
Date:
Subject: Re: Regex Replace with 2 conditions
Next
From: Abhra Kar
Date:
Subject: Found non-empty schema without metadata table error while migrating