Transaction Speed and real time database

Поиск
Список
Период
Сортировка
От moises
Тема Transaction Speed and real time database
Дата
Msg-id 20060721133804.256C19FAD5A@postgresql.org
обсуждение исходный текст
Ответ на Re: Transaction Speed  ("Adnan DURSUN" <a_dursun@hotmail.com>)
Ответы Re: Transaction Speed and real time database  (Martijn van Oosterhout <kleptog@svana.org>)
Список 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 по дате отправления:

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: How does the planner deal with multiple possible indexes?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [PERFORM] Sun Donated a Sun Fire T2000 to the PostgreSQL