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: [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'; firstname.lastname@example.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, -- Martijn van Oosterhout <email@example.com> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org