On 27.03.2017 08:14, Krishna Murthy Nazare wrote:
I am looking for scalability numbers a postgres database server can
scale up to given a specfic hardware resource. Like TPS. Searched on
the net, but did not come across. Please share if there are anything available from your test labs, production environments.
You would probably have to mention the intended usage to get something
even mildly relevant. Any database can easily scale into the terabytes (assuming it can address that much file space) - if you just do an
occasional insert or query. Conversely, TPS can be pretty high if you
resort to "SELECT 1;".
Most reliably is probably to do some benchmarking with a model of - or
even better your real use case. I guess you will get better results
when asking on the performance mailing list. It seems to have more
activity than this newsgroup. It is here:
https://www.postgresql.org/list/pgsql-performance/
Some more links
https://wiki.postgresql.org/wiki/Category:Benchmarking https://www.postgresql.org/docs/devel/static/pgbench.html
Kind regards
robert
--
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)