Re: [HACKERS] Transaction Speed and real time database

2006-07-24 Thread Joerg Hessdoerfer
Hi, On Monday 24 July 2006 11:26, Csaba Nagy wrote: > [snip] > > > OTOH, one has to be very careful to not mix terms here. In industrial > > (production floor) applications, the term 'real time database' refers to > > soemthing completely different than a relational, transactional DB. > > But "rel

Re: [HACKERS] Transaction Speed and real time database

2006-07-24 Thread Csaba Nagy
[snip] > OTOH, one has to be very careful to not mix terms here. In industrial > (production floor) applications, the term 'real time database' refers to > soemthing completely different than a relational, transactional DB. But "relational" and "transactional" are orthogonal, they don't imply/re

Re: [HACKERS] Transaction Speed and real time database

2006-07-24 Thread Joerg Hessdoerfer
Hi, On Monday 24 July 2006 10:33, Csaba Nagy wrote: > [please use "reply to all", otherwise you'll have what you just had: the > guy who you write goes home for the weekend and all the rest of the > people on the list who would answer you won't know there is soemthing to > answer...] > > On Fri, 2

Re: [HACKERS] Transaction Speed and real time database

2006-07-24 Thread Csaba Nagy
[please use "reply to all", otherwise you'll have what you just had: the guy who you write goes home for the weekend and all the rest of the people on the list who would answer you won't know there is soemthing to answer...] On Fri, 2006-07-21 at 13:39, moises wrote: > Sorry if I can't explain me

Re: [HACKERS] Transaction Speed and real time database

2006-07-21 Thread Andrew Dunstan
Hannu Krosing wrote: Ü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

Re: [HACKERS] Transaction Speed and real time database

2006-07-21 Thread Hannu Krosing
Ü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 m

Re: [HACKERS] Transaction Speed and real time database

2006-07-21 Thread Andrew Dunstan
inal- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de Martijn van Oosterhout Enviado el: viernes, 21 de julio de 2006 16:19 Para: moises CC: 'Adnan DURSUN'; pgsql-hackers@postgresql.org Asunto: Re: [HACKERS] Transaction Speed and real time database On Fri, Jul 21, 2006 at

Re: [HACKERS] Transaction Speed and real time database

2006-07-21 Thread Csaba Nagy
> [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 be

Re: [HACKERS] Transaction Speed and real time database

2006-07-21 Thread moises
#x27;Adnan DURSUN'; pgsql-hackers@postgresql.org Asunto: Re: [HACKERS] Transaction Speed and real time database On Fri, Jul 21, 2006 at 09:38:41AM +0200, moises wrote: > I want to know, in a hypothetical server, how many transaction postgres > support for a first approximation. > > I f

Re: [HACKERS] Transaction Speed and real time database

2006-07-21 Thread Martijn van Oosterhout
On Fri, Jul 21, 2006 at 09:38:41AM +0200, moises wrote: > I want to know, in a hypothetical server, how many transaction postgres > support for a first approximation. > > I found this data of MySQL and DB4o data bases but I can´t find any of > Postgres. I think you're asking the wrong question. I

Re: [HACKERS] Transaction Speed and real time database

2006-07-21 Thread Albe Laurenz
> Real time databases needs some other kinds of semantics and > features that postgres don't have. > > Postgres don't supports real time constrains semantics in > transactions. In other hands the concurrent transactions > don't wok well based on priorities of task. > > The program scheduler o

[HACKERS] Transaction Speed and real time database

2006-07-21 Thread moises
more important part?   Thanks M.   De: Adnan DURSUN [mailto:[EMAIL PROTECTED] Enviado el: jueves, 20 de julio de 2006 23:05 Para: moises; pgsql-hackers@postgresql.org Asunto: Re: [HACKERS] Transaction Speed                 This depends on your server capability and

Re: [HACKERS] Transaction Speed

2006-07-21 Thread Enver ALTIN
Hi, On Thu, Jul 20, 2006 at 02:36:53PM +0200, moises wrote: > For example Inserts, Update, delete, etc. If you need a storage for structured data, database servers are good to go. If you need a very fast "flow" of not-so-needed and okay-to-miss-we-can-regenerate type of data storage you can go wi

Re: [HACKERS] Transaction Speed

2006-07-20 Thread Zdenek Kotala
moises wrote: Can any body talk me how many transactions make postgres in a second? It depends on many things 1) speed of hardware/OS/number of disks/type of disks, if you use RAID or not ... 2) number concurrent access 3) size of processed data in one transaction 4) database model ... It n

Re: [HACKERS] Transaction Speed

2006-07-20 Thread Adnan DURSUN
, July 20, 2006 3:36 PM Subject: [HACKERS] Transaction Speed Can any body talk me how many transactions make postgres in a second? For example Inserts, Update, delete, etc.   I’m very interesting in this data, because I want to use postgres for a real time database for

[HACKERS] Transaction Speed

2006-07-20 Thread moises
Can any body talk me how many transactions make postgres in a second? For example Inserts, Update, delete, etc.   I’m very interesting in this data, because I want to use postgres for a real time database for process control.   Thanks and regards   ___