Re: Transaction Speed and real time database

Поиск
Список
Период
Сортировка
От Csaba Nagy
Тема Re: Transaction Speed and real time database
Дата
Msg-id 1153502899.5683.312.camel@coppola.muc.ecircle.de
обсуждение исходный текст
Ответ на Re: Transaction Speed and real time database  ("moises" <moises@cedaivc.co.cu>)
Список pgsql-hackers
> [snip] Suppose that every
> body say me that POStgres is to slow for real time databases, then I will be
> very full trying to resolve this problems with postgres, don't think that?

I think you didn't understand correctly: postgres is not slow, it is
just not suitable for real RT applications because of a few reasons,
which in fact make other data bases also not suitable for this purpose.

The main concern is that a RT application usually needs predictable
response times, possibly with guaranties for upper bounds of response
times... and most data bases which are transactional and offer
concurrent access won't give you such guaranties, due to locking issues.

The question is, your application is really RT in the proper sense of
the word, or it is just an OLTP application which needs to be fast but
won't cause a nuclear explosion if one response in 100 will be slower
than expected... in that case postgres might be good for you.

Cheers,
Csaba.




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

Предыдущее
От: "moises"
Дата:
Сообщение: Re: Transaction Speed and real time database
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: Transaction Speed and real time database