Re: cloudNativePg bootstrap from dump - Mailing list pgsql-admin

From Ron Johnson
Subject Re: cloudNativePg bootstrap from dump
Date
Msg-id CANzqJaBf69-+stEP=uDXXgBJtkbEgnMmWgMaBw4O97P0oV+dUg@mail.gmail.com
Whole thread Raw
In response to Re: cloudNativePg bootstrap from dump  (Alessandro Dentella <sandro.dentella@gmail.com>)
Responses Re: cloudNativePg bootstrap from dump
List pgsql-admin
On Fri, May 10, 2024 at 12:16 PM Alessandro Dentella <sandro.dentella@gmail.com> wrote:


Il giorno ven 10 mag 2024 alle ore 17:49 Scott Ribe <scott_ribe@elevated-dev.com> ha scritto:
Is it possible that it is not stuck, but simply processing rows of a large table? Try with the -e option, then you'll see.

I'd say no. based on the fact tat If I query the dimension with \l+ I see 85 MB, that is exactly the same dim I find in a db initialized with the same dump. where the import finishes correctly (not in k8s).

On the other side If I add -e and look at the issued SQL statement, many create table statement are missing (but the table are there).

iotop and pg_stat_activity will tell you what is (or is not) happening.

pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: Re: Observation with Postgres table size
Next
From: Wells Oliver
Date:
Subject: Re: Request for featu VACUUM FULL updates pg_stat_all_tables.last_vacuum