From: | Poul Møller Hansen <freebsd(at)pbnet(dot)dk> |
---|---|
To: | Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
Subject: | Why are pg_restore taking that long ? |
Date: | 2012-05-15 15:27:56 |
Message-ID: | 4FB275FC.70502@pbnet.dk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have just restored a database about 347GB in size
postgres=# select * from pg_database_size('dbname');
pg_database_size
------------------
346782483256
using this command:
pg_restore -d dbname -O -Fc dbname.backup
It started at 13/5 21:28 and at 14/5 18:47 all user tables were imported
and indexes were build.
It's on a single SATA drive, so I think that's OK.
But the restore wasn't finished until 15/5 08:47
Looking at the files in the database, all files touched after 14/5
18:47, are system tables:
filename relfilenode
11750 pg_constraint_conrelid_index
11752 pg_constraint_oid_index
11735 ?
11736 ?
11733 ?
11757 pg_index
11714 ?
11808 pg_trigger_tgconstraint_index
11810 pg_trigger_oid_index
11751 pg_constraint_contypid_index
11809 pg_trigger_tgrelid_tgname_index
11837 pg_depend_depender_index
11744 pg_constraint
11749 pg_constraint_conname_nsp_index
11803 pg_trigger
11835 pg_depend
11838 pg_depend_reference_index
11826 pg_namespace
autovacuum was disabled.
Why is it working that long on the system tables ?
dbname=# select version();
version
------------------------------------------------------------------------------------------------------------
PostgreSQL 9.1.3 on x86_64-unknown-linux-gnu, compiled by gcc
(Ubuntu/Linaro 4.6.3-1ubuntu2) 4.6.3, 64-bit
Thanks,
Poul
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Crawford | 2012-05-15 15:29:35 | Re: Vacuum does not show in pg_stat_all_tables |
Previous Message | Merlin Moncure | 2012-05-15 13:16:11 | Re: Global Named Prepared Statements |