CODEWITHSUNDEEP
postgresqldatabase-restorepostgresql-9.5pg-restore
Juan Carlos Oropeza
Juan Carlos Oropeza

Reputation: 48197

Why Restore doesnt end?

First I thought was too big restore, so instead of a single 2GB (compress) db backup I split into several backup, one for schema. This schema map has 600 Mb. Next step would be split for tables.

This one have some spatial data from my country map, not sure if that is relavant.

As you can see almost 2h. The disk arent really in use anymore. When restore start, disk reach 100% several times. But last hour has been flat 0%

enter image description here

And as you can see here I can access the data in the all the restored tables. So looks like is already done.

enter image description here

Is this normal?. There is anything I can check to see what is doing the restore?

Hardware Setup:

EDIT

SELECT application_name, query, * 
FROM pg_stat_activity
ORDER BY application_name, query;

enter image description here

Upvotes: 0

Views: 151

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 247123

Yes, that seems perfectly normal.

Most likely you observe index or constraint creation. Look at the output of

SELECT * FROM pg_stat_activity;

to confirm that (it should contain CREATE INDEX or ALTER TABLE).

It is too late now, but increasing maintenance_work_mem will speed up index creation.

Upvotes: 2

Related Questions