Simon Riggs wrote:
On Mon, 2005-04-18 at 08:50 +0400, Nurlan Mukhanov (AL/EKZ) wrote:If you are doing a restore off a pg_dump, did you dump the data as inserts? This takes a lot more time to restore.
I'm trying to restore my database from dump in several parrallel processes, but restore process works too slow.
Number of rows about 100 000 000,
RAM: 8192M
CPU: Ultra Sparc 3
Number of CPU: 4
OS: SunOS sun 5.8
RDBMS: PostgreSQL 8.0
How to encrease postgresql speed? Why postgres took only 5.0% of CPU time?
When you say restore...what are you actually doing? An archive recovery?
A reload?
A file-level restore of database?
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend