Re: Hardware recommendation: which is best
От | Ron Johnson |
---|---|
Тема | Re: Hardware recommendation: which is best |
Дата | |
Msg-id | 46E6FC4B.2090408@cox.net обсуждение исходный текст |
Ответ на | Re: Hardware recommendation: which is best ("Phoenix Kiula" <phoenix.kiula@gmail.com>) |
Список | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 09/11/07 12:02, Phoenix Kiula wrote: > On 12/09/2007, Ron Johnson <ron.l.johnson@cox.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-----
В списке pgsql-general по дате отправления: