PostgreSQL Performance

From: "Milosz Miecznik" <michoo(dot)inne(at)mga(dot)com(dot)pl>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: PostgreSQL Performance
Date: 2004-06-09 14:34:22
Message-ID: 003401c44e2e$db738660$9801a8c0@MGA.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi!

I have very important question about performance of PostgreSQL Database. How
it will work with:
- about 3000000 insert operation per day,
- about 1000000 selects per day,
- about 100 still connected users?
What hardware platform shall I use for such big database (RAM, No. of CPUs,
Hard discs capasity...?)
What operating system shall I use? (I think about RedHat 8.x)

Can You help and reply to me, please.
Milosz Miecznik

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Honza Pazdziora 2004-06-09 14:43:38 Re: [HACKERS] Refined LC_COLLATE or multiple database clusters?
Previous Message Tom Lane 2004-06-09 14:26:55 Re: Corrupted or deleted pg_tables