sean finney on 5 Apr 2010 01:24:27 -0700

[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]

Re: [PLUG] postgres data loading

On Fri, Apr 02, 2010 at 02:53:54PM -0400, John Karr wrote:
> Any ideas on how to do this load faster? Normally this load would occur
> about once every 3 months, but in times peak activity it could be weekly and
> it wouldn't be acceptable to have the application down for a day for every
> load.

what postgres version?  8.3 or 8.4 offers PITR recovery which would probably
be the fastest way to replace one large dataset with another (think of it
like transferring a journalled version of the datadir between hosts).


Attachment: signature.asc
Description: Digital signature

Philadelphia Linux Users Group         --
Announcements -
General Discussion  --