Postgres Pro
Downloads
Home   >   mailing lists

Re: Reducing pg_dump & pg_restore times - Mailing list pgsql-general

From Robert Treat
Subject Re: Reducing pg_dump & pg_restore times
Date
Msg-id 200610262350.46889.xzilla@users.sourceforge.net
Whole thread Raw
In response to Re: Reducing pg_dump & pg_restore times  (Chris <dmagick@gmail.com>)
List pgsql-general
Tree view 
On Thursday 26 October 2006 02:20, Chris wrote:
> Coder At Heart wrote:
> > Hi!
> >
> > Restore & backup take time in the tune of 6 hrs on a Linux, 4 proc, 32 G
> > RAM machine for a 60GB database.
>
> Please always cc the mailing list.
>
> I've never played with databases that large so I don't know if that's
> good or bad.. others on the list will be able to offer advice/suggestions.

A while back I wrote something up on increasing restore times, might be worth
checking out.

http://people.planetpostgresql.org/xzilla/index.php?/archives/133-Getting-faster-database-restores-on-postgresql-8.1.html

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

pgsql-general by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: [SQL] Can we convert from Postgres to Oracle !!???
Next
From: Richard Broersma Jr
Date:
Subject: Re: pg_dumpall failing from possible corrupted shared memory