Dream Server?
От | Gavin M. Roy |
---|---|
Тема | Dream Server? |
Дата | |
Msg-id | 001d01c1af58$85df6ec0$72fea8c0@Gavin обсуждение исходный текст |
Ответы |
Re: Dream Server?
|
Список | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I'm currently running a 4 Gig 11 million row database and am looking to build a "dream server" for it. I am currently running a dual p3 1GHz system with 10k rpm scsi drives and 4 gigs of ram (which I have configured pgsql to use all of) and I'm concerned about performance once the db doubles in size, which should be in 6 mos to a year at the latest. First off, If money was no concern, what would you buy as the ultimate postgresql server running linux? Second off, on a more technical note, does pgsql take advantage of multiple processors. If I had a 8 way 800 MHz Xeon would the machine blow away a 2GHz P4? How much is CPU a factor compared to memory? Disk speed? I want to be able to do large volume selects on tables with more than 5 million rows and not have the server blink at other requests put in at the same time. Any hints or suggestions/experience here would be appreciated. Thanks, Gavin -----BEGIN PGP SIGNATURE----- Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com> iQA/AwUBPGGlgn9xeBXAlKqsEQJPywCfenV2bHDKJ0czKLy2qbaoj+hiow8AoNaT 9gYOTvmzFR9+YIjA5MQwjSMN =B6Ak -----END PGP SIGNATURE-----
В списке pgsql-general по дате отправления: