| From: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
|---|---|
| To: | Milosz Miecznik <michoo(dot)inne(at)mga(dot)com(dot)pl> |
| Subject: | Re: PostgreSQL Performance |
| Date: | 2004-06-11 14:57:35 |
| Message-ID: | 40C9C85F.3020509@bigfoot.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Milosz Miecznik wrote:
> 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)
I don't have 3000000 insert per day, but 3000000 update per day for
the rest I have more then your numbers and in 3 years I had no one
singol data loss or performance problem.
regards
Gaetano Mendola
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jason Tishler | 2004-06-11 15:24:19 | Re: [ADMIN] INITDB-error - end-of-copy marker error |
| Previous Message | Martin Marques | 2004-06-11 11:48:49 | Re: [GENERAL] out of memory error |