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-----
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 |