Ü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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
