Re: PostgreSQL on the internet - Mailing list pgsql-general

From Richard Huxton
Subject Re: PostgreSQL on the internet
Date
Msg-id 47543766.1070004@archonet.com
Whole thread Raw
In response to Re: PostgreSQL on the internet  (Bob Pawley <rjpawley@shaw.ca>)
List pgsql-general
Bob Pawley wrote:
> At the moment the database dump is 4.1 meg.
>
> I suspect the end result will be less than 10 meg including the user's
> information.
>
> Is there other size information you need?

Well, you'll want estimates of:
1. Total number of users (assuming you don't drop the database on the
server-side).
2. Total number of concurrent users
3. Their activity patterns

At a wild guess, your limiting factor will be one of:
1. User upload speed (they might be on a slow ADSL/wifi link)
2. Database creation

I'd be tempted to have the local app send a checksum to the server and
see if it needs to upload the DB at all.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Bob Pawley
Date:
Subject: Re: PostgreSQL on the internet
Next
From: "Mikko Partio"
Date:
Subject: rpm's for 8.3 beta 4