Re: Hardware recommendation: which is best

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Hardware recommendation: which is best
Date: 2007-09-11 20:36:27
Message-ID: 46E6FC4B.2090408@cox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 09/11/07 12:02, Phoenix Kiula wrote:
> On 12/09/2007, Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> wrote:
>> How (on average) large are the records you need to insert, and how
>> evenly spread across the 24 hour day do the inserts occur?
>
>
> There will be around 15,000 inserts in a day. Each insert will have
> several TEXT columns, so it is difficult to predict, but about 30,000
> to 100,000 characters in each row. And yes, the inserts will be very
> consistently timed every day.

15000*100000 = 1.5GB.

1.5GB / (24*60) = ~1 binary MB.

Any computer that that can't write 1 megabyte per minute in a day
should have been retired in 1970.

So.....

Unless there's something that you aren't telling us, this should be
handleable by a Wal-Mart Special with an extra-large disk in it.

- --
Ron Johnson, Jr.
Jefferson LA USA

Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFG5vxLS9HxQb37XmcRAoneAKCsw0W92jmySlGaRFpkZsvIJovTJwCgqPFg
j4Fp2uV5vf+OIVhnuJSaQxs=
=4u83
-----END PGP SIGNATURE-----

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Laimonas Simutis 2007-09-11 22:55:33 tsearch2 and parsing host strings
Previous Message Sean Davis 2007-09-11 20:04:14 pam authentication