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

Basic questions before start

From: gogulus(at)eqnet(dot)hu
To: pgsql-general(at)postgresql(dot)org
Subject: Basic questions before start
Date: 2003-07-29 17:04:04
Message-ID: 20030729170404.6EE9324ADC7@mail.eqnet.hu (view raw or flat)
Thread:
Lists: pgsql-general
Hello,

  I am planning to implement a system, where there is one Master database running on a Linux box with as many resources as necessary, and there are one or more client pc computers,with processor speed of 100 Mhz, memory of 32-64 Mbytes and a 10Mb/s network card.

  The major task is that the clients should work on the actual state of data, which means the basic database (data, unchangeable for clients), and some statistical data on other clients, and they should not stop work when there is no network connection to the master pc. They should give back their detailed transactions on the basic data to the master pc.

  For this reason I consider to run postgres on the client computers, but I am quite concerned about system overhead.

  The clients will only do basic database work: 
   - selects from the database, without nested selects (or with nested selects with the maximum of 1-2 levels) 
   - writing their transactions into the database, with commit/rollback functionality.
   - update some tables because of synchronization with master db.
   - update some tables to summarize the value of transactions. (They could be done by triggers, but if they need resources, there is an existing solution with basic operations).

  Size of the database: The basic data includes 50-100.000 elements in 3-4 tables each, and much less data in other tables. The number of tables is around 100.

  I would like to know the opinion of experienced users of Postgres, if I can embark upon this road, or should choose an other way which uses an other db system with lower resource-needs.

  Thanks in advance,

  Gogulus

Responses

pgsql-general by date

Next:From: Jonathan BartlettDate: 2003-07-29 17:13:06
Subject: Re: CREATE TABLE with REFERENCE
Previous:From: Andrew SullivanDate: 2003-07-29 17:02:44
Subject: Re: concurrent writes

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