Re: Basic questions before start
От | Paul Thomas |
---|---|
Тема | Re: Basic questions before start |
Дата | |
Msg-id | 20030729192456.G26716@bacon обсуждение исходный текст |
Ответ на | Basic questions before start (gogulus@eqnet.hu) |
Список | pgsql-general |
On 29/07/2003 18:04 gogulus@eqnet.hu wrote: > 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. I've run Linux together with Gnome 1.4, Apache, Sendmail, Postgresql and a Java VM on a laptop with 64MB RAM with no problem. You just have to accept that it will be a bit slower. HTH -- Paul Thomas +------------------------------+---------------------------------------------+ | Thomas Micro Systems Limited | Software Solutions for the Smaller Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk | +------------------------------+---------------------------------------------+
В списке pgsql-general по дате отправления: