pg 8.3beta 2 restore db with autovacuum report
От | andy |
---|---|
Тема | pg 8.3beta 2 restore db with autovacuum report |
Дата | |
Msg-id | 4728C094.7060404@squeakycode.net обсуждение исходный текст |
Ответы |
Re: pg 8.3beta 2 restore db with autovacuum report
|
Список | pgsql-hackers |
with autovacuum enabled with default settings, cramd.sql is 154M: andy@slacker:/pub/back$ time pg_restore -Fc -C -d postgres cramd.sql real 3m43.687s user 0m11.689s sys 0m0.868s andy@slacker:/pub/back$ during restore we see scary things like: root@slacker:~# ps awx|grep postgres 2497 ? Ss 0:00 postgres: logger process 2499 ? Ss 0:00 postgres:writer process 2500 ? Ss 0:00 postgres: wal writer process 2501 ? Ss 0:00 postgres: autovacuumlauncher process 2502 ? Ss 0:00 postgres: stats collector process 2519 pts/0 S+ 0:12 pg_restore-Fc -C -d postgres cramd.sql 2521 ? Ss 1:04 postgres: andy cramd [local] CREATE INDEX waiting 2526 ? Ss 0:03 postgres: autovacuum worker process cramd 2571 ? Ss 0:01 postgres: autovacuumworker process cramd 2582 pts/1 R+ 0:00 grep postgres Now I dropdb and disable autovacuum, restart pg: andy@slacker:/pub/back$ time ( pg_restore -Fc -C -d postgres cramd.sql; vacuumdb -z cramd ) real 3m47.229s user 0m9.933s sys 0m0.744s Sweet, about the same amount of time. Performed on my laptop, an asus m5n, running slackware 12 -Andy
В списке pgsql-hackers по дате отправления: