Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance

> 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
Aglio Database Solutions
San Francisco

In response to

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group