"scott.marlowe" <[EMAIL PROTECTED]> writes: > > 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.
> 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. Well there's some info missing. Like what would you actually be _doing_ with these data? 15,000 inserts per day is nothing. But after 18 months that's over 5M records not including the 10% growth rate. 5M records isn't really all that much but it's enough that it's possible to write slow queries against it. If you're doing big batch updates or complex reports against the data that will be more interesting than the inserts. -- greg ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly