Re: PostgreSQL Performance - Mailing list pgsql-admin

From Gaetano Mendola
Subject Re: PostgreSQL Performance
Date
Msg-id 40C9C85F.3020509@bigfoot.com
Whole thread Raw
In response to PostgreSQL Performance  ("Milosz Miecznik" <michoo.inne@mga.com.pl>)
List 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


pgsql-admin by date:

Previous
From: Martin Marques
Date:
Subject: Re: [GENERAL] out of memory error
Next
From: Bruce Momjian
Date:
Subject: Re: Calculating size of the database tables