> 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?
Aglio Database Solutions
In response to
pgsql-performance by date
|Next:||From: Tim Mohler||Date: 2003-03-05 20:26:27|
|Subject: Batch copying of databases|
|Previous:||From: Richard Huxton||Date: 2003-03-05 19:31:44|
|Subject: Re: Planner matching constants across tables in a|