Re: Transaction Speed and real time database - Mailing list pgsql-hackers

From Csaba Nagy
Subject Re: Transaction Speed and real time database
Date
Msg-id 1153502899.5683.312.camel@coppola.muc.ecircle.de
Whole thread Raw
In response to Re: Transaction Speed and real time database  ("moises" <moises@cedaivc.co.cu>)
List 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 by date:

Previous
From: "moises"
Date:
Subject: Re: Transaction Speed and real time database
Next
From: Andrew Dunstan
Date:
Subject: Re: Transaction Speed and real time database