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

From Hannu Krosing
Subject Re: Transaction Speed and real time database
Date
Msg-id 1153514556.2912.7.camel@localhost.localdomain
Whole thread Raw
In response to Re: Transaction Speed and real time database  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: Transaction Speed and real time database
List pgsql-hackers
Ühel kenal päeval, R, 2006-07-21 kell 13:29, kirjutas Andrew Dunstan:
> What you are asking is essentially the equivalent of asking "How long is 
> a piece of string?" The question is meaningless and so will be any 
> answer. The fact that there are web sites which are happy to supply you 
> with meaningless information doesn't mean we should follow suit.
> 
> And frankly, I would be very dubious about using PostgreSQL or just 
> about any other RDBMS in a Real Time System, hard or soft.

It would probably be possible to get constant-time inserts into an
indexless table, once checkpoints are spread out over the whole
checpoint interval, as described by the NTT staff at the conference, but
this is probably the only RT compatible scenario you can expect from an
RDBMS.

Another way to get RT is just use long required completion times and
light enough load on db that you always meet your time limit. 

Remember, RT does not neccesarily mean Fast it just needs to be
Predictable!

-- 
----------------
Hannu Krosing
Database Architect
Skype Technologies OÜ
Akadeemia tee 21 F, Tallinn, 12618, Estonia

Skype me:  callto:hkrosing
Get Skype for free:  http://www.skype.com



pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: contrib promotion?
Next
From: "Joshua D. Drake"
Date:
Subject: Re: contrib promotion?