Re: Transaction Speed

Поиск
Список
Период
Сортировка
От Zdenek Kotala
Тема Re: Transaction Speed
Дата
Msg-id 44BFF309.4000104@sun.com
обсуждение исходный текст
Ответ на Transaction Speed  ("moises" <moises@cedaivc.co.cu>)
Список pgsql-hackers
moises wrote:
> Can any body talk me how many transactions make postgres in a second?
> 

It depends on many things
1) speed of hardware/OS/number of disks/type of disks, if you use RAID 
or not ...
2) number concurrent access
3) size of processed data in one transaction
4) database model
...

It not possible determine. You must take some machine and perform some 
own test.


> 
>  
> 
> I’m very interesting in this data, because I want to use postgres for a 
> real time database for process control.

I'm not sure if postgres is good database for real time application. You 
need know maximal response time for realtime application and I afraid 
that postgres is not good choice for RTA. (MySQL, Firebird, Oracle ... 
have same limitation ...)

Zdenek


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Adnan DURSUN"
Дата:
Сообщение: Re: Transaction Speed
Следующее
От: Joshua Reich
Дата:
Сообщение: Using EXPLAIN in regressions?