Re: Batch copying of databases - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Batch copying of databases
Date
Msg-id 200303051137.39517.josh@agliodbs.com
Whole thread Raw
In response to Batch copying of databases  ("Tim Mohler" <tamohler@nyc.rr.com>)
List pgsql-performance
Tim,

> I'm new to Postgres, and am not even the DBA for the system. I'm just a
> sysadmin trying to make things run faster. Every month, we copy over a 25
> million row table from the production server to the reporting server. Total
> size is something like 40 gigabytes.

Are you doing this through COPY files, or some other means?

--
Josh Berkus
josh@agliodbs.com
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: "Tim Mohler"
Date:
Subject: Batch copying of databases
Next
From: "Shridhar Daithankar"
Date:
Subject: Re: Batch copying of databases