Re: Batch copying of databases

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "Tim Mohler" <tamohler(at)nyc(dot)rr(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Batch copying of databases
Date: 2003-03-05 19:37:39
Message-ID: 200303051137.39517.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)agliodbs(dot)com
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tim Mohler 2003-03-05 20:26:27 Batch copying of databases
Previous Message Richard Huxton 2003-03-05 19:31:44 Re: Planner matching constants across tables in a