Re: Server specs to run PostgreSQL

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

On 05/08/07 14:04, MaRCeLO PeReiRA wrote:
> Hi there,
>
> Actually my PostgreSQL server is running on a Athlon
> XP 1800+, 512Mb RAM, IDE Disks, 10/100 netcard.
>
> I would like to buy a new server, could you please
> give me some information about the specs??
>
> Is it important to have a Dual (or even Quad)
> processor??? Will PostgreSQL use them??
>
> What about memory??? How much???
>
> SCSI Disks and 10/100/1000 netcards, it's ok!! No
> doubt!
>
> It's a medium use server, about 3000 transactions/day.

Presumably in the 10 hours from 08:00 to 18:00? If so, that's:
300 txn/hr
5 txn/minute
0.08333 txn/sec.

Your existing server can handle that.

Is there something you aren't telling us? Is the system 99.99%
SELECTs? That would be 30,000,000 SELECTS/day. Obviously a burden
to any but the biggest systems.

Are your tables indexed properly for the given queries? More hw
won't solve crappy/non-existent index support

How complicated are the queries? Simple and low volume, or 15 table
OLAP mega-joins?

For that matter, how complicated are the transactions? Does each
INSERT trigger 18 UPDATEs and 10 DELETEs? None of which have proper
index support?

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

iD8DBQFGQNHbS9HxQb37XmcRAicrAJ4740CpjG4jERQnW/ta0VkhjR++RQCg4r3g
BRAWEy4mdnyKJzjehluGbb4=
=HbGC
-----END PGP SIGNATURE-----