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

From moises
Subject Transaction Speed and real time database
Date
Msg-id 20060721133804.256C19FAD5A@postgresql.org
Whole thread Raw
In response to Re: Transaction Speed  ("Adnan DURSUN" <a_dursun@hotmail.com>)
Responses Re: Transaction Speed and real time database  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-hackers

Thanks for your answer,

I have experience with postgres and I know perfectly that not a TOY.

But some concepts of real time system don’t based only in speed.

 

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 of transaction based on real time mechanism like system how RTAI, or RTlinux, and much more.

POstrgres need to be extending for real time databases.

 

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.

A mite that postgres is slow, but I need some numbers, insertion speed, and update speed is the more important part?

 

Thanks

M.

 


De: Adnan DURSUN [mailto:a_dursun@hotmail.com]
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 performance.. You can use PostgreSQL as real time database. It is real not a toy :-)

 

Adnan DURSUN
ASRIN Bilisim Ltd.

Turkey

----- Original Message -----

From: moises

Sent: Thursday, 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 process control.

 

Thanks and regards

 

________________________________________

M.Sc.Moisés Herrera Vázquez

Especialista Superior en Automática

Empresa de Automatización Integral, CEDAI

Sucursal Villa Clara.

Teléfono: (53) 42 -203311

_______________________________________

 

 

 

pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: How does the planner deal with multiple possible indexes?
Next
From: Tom Lane
Date:
Subject: Re: [PERFORM] Sun Donated a Sun Fire T2000 to the PostgreSQL