From: | Colton A Smith <smith(at)cs(dot)utk(dot)edu> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | an atypical pg_restore? |
Date: | 2007-01-22 15:11:33 |
Message-ID: | Pine.LNX.4.62.0701220947260.26094@cetus5.cs.utk.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi:
I'm in the midst of upgrading from 8.1.5
to 8.2.1 usng pg_dumpall and pg_restore.
My database is about 95 G in size and contains
several very large tables having indexed columns of
the geometry datatype (PostGis). Otherwise,
my database is pretty conventional. My problem:
the restore is taking forever. It's now day
12 and about 86 G has been restored.
Here are some details:
1) Hardware:
SunOS 5.9 Generic_117171-07 sun4u sparc
SUNW,Sun-Fire-V240
System Configuration: Sun Microsystems sun4u Sun Fire V240
System clock frequency: 167 MHZ
Memory size: 2GB
==================================== CPUs ====================================
E$ CPU CPU Temperature
CPU Freq Size Implementation Mask Die Amb. Status
Location
--- -------- ---------- ------------------- ----- ---- ---- ------ --------
0 1503 MHz 1MB SUNW,UltraSPARC-IIIi 3.4 - - online MB/P0
1 1503 MHz 1MB SUNW,UltraSPARC-IIIi 3.4 - - online MB/Pa
top reveals:
load averages: 0.04, 0.04, 0.05
48 processes: 47 sleeping, 1 on cpu
CPU states: 95.5% idle, 2.4% user, 2.1% kernel, 0.0% iowait, 0.0% swap
Memory: 2048M real, 1403M free, 118M swap in use, 3384M swap free
PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
29520 postgres 1 60 0 59M 44M sleep 913:46 2.26% postgres
etc, etc.
2) Dump/restoration commands: pg_dumpall (no options) and
pg_restore (no options).
3) Restoration progress as of today:
day gigabytes restored (cumulative)
--- -------------------------------
1
2 7.7
3 17
4 26
5 35
6 43
7 52
8 57
9 83
10 84
11 85
12 86
In the beginning, I was getting about
9 G restored daily. But on day 9 and thereafter,
the rate slowed to 1 G. On day 9, the
restoration of the indices began. My biggest
indices are those covering the geometry columns.
My question: is my experience here atypical?
Thanks!
From | Date | Subject | |
---|---|---|---|
Next Message | Benjamin Otto | 2007-01-22 15:41:59 | Installation under WinXP |
Previous Message | Devrim GUNDUZ | 2007-01-22 11:48:40 | Re: Startup problem |