Re: PostgreSQL Performance

Поиск
Список
Период
Сортировка
От Gaetano Mendola
Тема Re: PostgreSQL Performance
Дата
Msg-id 40C9C85F.3020509@bigfoot.com
обсуждение исходный текст
Ответ на PostgreSQL Performance  ("Milosz Miecznik" <michoo.inne@mga.com.pl>)
Список 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 по дате отправления:

Предыдущее
От: Martin Marques
Дата:
Сообщение: Re: [GENERAL] out of memory error
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Calculating size of the database tables