Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

Next:From: Heikki LinnakangasDate: 2007-10-31 17:56:09
Subject: Re: Postgresql 8.3 beta crash
Previous:From: Michael GlaesemannDate: 2007-10-31 17:38:04
Subject: Re:

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group