Re: postgres in realtime mode - Mailing list pgsql-novice

From Chris Browne
Subject Re: postgres in realtime mode
Date
Msg-id 60irmlvzfi.fsf@dba2.int.libertyrms.com
Whole thread Raw
In response to postgres in realtime mode  ("nitin quick" <quick.nitin@gmail.com>)
List pgsql-novice
quick.nitin@gmail.com ("nitin quick") writes:
> hello everybody,
> i am using postgres for someime now for storing my maps etc.
> Can postgresql can be used in real time domain. I may be using open source rtlinux as rtos.
> I mean how i can show it is working as real time os.
> Is sth on this issue already available ?

Real Time systems generally mandate that tasks are guaranteed to
complete without more than some pre-defined amount of delay.

SQL introduces considerable nondeterminism in that different queries
that look much the same may have dramatically different performance
characteristics.

I don't think you'll be able to guarantee that all queries will
complete in less than some given interval of time.

It's entirely likely that PostgreSQL can run atop some RTOSes; I don't
think it could be safely considered as a candidate component for a
real time system without taking exceeding care to ensure that database
operations were selected carefully.
--
let name="cbbrowne" and tld="cbbrowne.com" in name ^ "@" ^ tld;;
http://www.ntlug.org/~cbbrowne/languages.html
MS-Windows: Proof that P.T. Barnum was correct.

pgsql-novice by date:

Previous
From: "Parang Saraf"
Date:
Subject: graph plottin engines compatible with postgres
Next
From: "Fuzzydave"
Date:
Subject: Insert Statement By Trigger Function