On Wed, 3 Dec 2003 [EMAIL PROTECTED] wrote: > Dear all > > We would be recommending to our ct. on the use of Postgresql db as compared > to MS SQL Server. We are targetting to use Redhat Linux ES v2.1, Postgresql > v7.3.4 and Postgresql ODBC 07.03.0100. > > We would like to know the minimum specs required for our below target. The > minimum specs is referring to no. of CPU, memory, harddisk capacity, RAID > technology etc. And also the Postgresql parameters and configuration to run > such a system. > > 1) We will be running 2 x Postgresql db in the machine. > > 2) Total number of connections to be around 100. The connections from the > clients machines will be in ODBC and socket connections. > > 3) Estimated number of transactions to be written into the Postgresql db is > around 15000 records per day. > > > The growth rate in terms of number of connections is around 10% per year > and the data retention is kept on average at least for 18 months for the 2 > databases. > > Are there any reference books or sites that I can tap on for the above > requirement?
Like another poster pointed out, this is a walk in the park for postgresql. My workstation (1.1GHz celeron, 40 gig IDE drive, 512 Meg memory) could handle this load while still being my workstation. :-) ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings