Re: Copying database directory

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-admin(at)postgresql(dot)org>,<Vadim(dot)Tsing(at)snapon(dot)com>
Subject: Re: Copying database directory
Date: 2010-12-18 19:50:33
Message-ID: 4D0CBC290200002500038793@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Tsing, Vadim" wrote:

> Out databases vary in size, bat many of the have tables with
> millions of rows. Those tables are indexed. One of the databases
> that we've timed, took about 12 min to load the data and another
> 10-12 min to re-create indexes. The dump file is about 400 MB. This
> is by far not the largest one we will have to deal with.

Any chance that you can just have the app make requests to a database
on your server, and not ship the database with the software? Maybe
even do this as a web app?

-Kevin

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tsing, Vadim 2010-12-18 20:09:17 Re: Copying database directory
Previous Message Tsing, Vadim 2010-12-18 18:58:23 Re: Copying database directory