| From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | Chris <dmagick(at)gmail(dot)com>, Coder At Heart <coder(dot)at(dot)heart(at)gmail(dot)com>, "C(dot)M(dot) Shivkumar" <shivkumar(dot)cm(at)gmail(dot)com> |
| Subject: | Re: Reducing pg_dump & pg_restore times |
| Date: | 2006-10-27 03:50:45 |
| Message-ID: | 200610262350.46889.xzilla@users.sourceforge.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Broersma Jr | 2006-10-27 04:00:30 | Re: pg_dumpall failing from possible corrupted shared memory |
| Previous Message | Jim C. Nasby | 2006-10-27 03:09:38 | Re: regarding PostgreSQL |