Re: cloudNativePg bootstrap from dump

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: cloudNativePg bootstrap from dump
Дата
Msg-id CANzqJaBf69-+stEP=uDXXgBJtkbEgnMmWgMaBw4O97P0oV+dUg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: cloudNativePg bootstrap from dump  (Alessandro Dentella <sandro.dentella@gmail.com>)
Ответы Re: cloudNativePg bootstrap from dump  (Alessandro Dentella <sandro.dentella@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Wells Oliver
Дата:
Сообщение: Re: Observation with Postgres table size
Следующее
От: Wells Oliver
Дата:
Сообщение: Re: Request for featu VACUUM FULL updates pg_stat_all_tables.last_vacuum