pg 8.3beta 2 restore db with autovacuum report

From: andy <andy(at)squeakycode(dot)net>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: pg 8.3beta 2 restore db with autovacuum report
Date: 2007-10-31 17:51:16
Message-ID: 4728C094.7060404@squeakycode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


with autovacuum enabled with default settings, cramd.sql is 154M:

andy(at)slacker:/pub/back$ time pg_restore -Fc -C -d postgres cramd.sql

real 3m43.687s
user 0m11.689s
sys 0m0.868s
andy(at)slacker:/pub/back$

during restore we see scary things like:

root(at)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: autovacuum launcher 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: autovacuum worker process cramd
2582 pts/1 R+ 0:00 grep postgres

Now I dropdb and disable autovacuum, restart pg:

andy(at)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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2007-10-31 17:56:09 Re: Postgresql 8.3 beta crash
Previous Message Michael Glaesemann 2007-10-31 17:38:04 Re: