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

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.

cheers

andrew

moises wrote:
> Hello, 
> Thanks for your answer.
> Maybe I asking a wrong question, but I just need some ideas like you say
> that posgres can insert 100,000 rows per second, is a good approximation...
> In other hand if you visit some links like
> http://developer.db4o.com/forums/post/25599.aspx
> You will find something like this in Spanish
> You can store 250 millions objects with just constant 40 MB RAM and constant
> insertions about 8.000 objects per second -- these measures had been take in
> a show HDD 5600 rpm. It had been stored 100.000 objects with less than
> constant 2MB RAM. Db4o can store in 10 millions of objects in 400
> milliseconds.
>
> How can you see, this numbers are just I want but for postgres.
>
> I know that hardware is very important, join to OS and config of Shared
> Memory, System V, etc, but I just looking for an Idea. 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?
>
> Thanks again.
>
> Moises
>
> -----Mensaje original-----
> De: pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org] 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 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 think what you want is
> "what performence does postgresql get on benchmark X with hardware Y".
> I don't beleive you actually get performence numbers for other
> databases without a whole list of constraining factors. You need to be
> a lot more specific about what you want to know. You can find
> benchmarks on the web, but really you need to evaluate whether they're
> testing what you want to know.
>
> But ok, here's a number: I can insert 100,000 rows per second on this
> machine next to me. How does that help you? It doesn't: you don't know
> the machine or the software or how it's configured or what I'm
> inserting. You don't even know if this machine exists (hint: it
> doesn't).
>
> Also, insert/update speeds are useless measurements. If all you want is
> that, please look at berkley DB. PostgreSQL is a SQL compliant
> database.
>
> Anyway, here are some sites to help you formulate your question better:
>
> http://www.geocities.com/mailsoftware42/db/
> http://www.devx.com/dbzone/Article/29480?trk=DXRSS_DB
>
> Hope this helps,
>