Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.postgresql > #735

Re: Postgres scalability numbers

Show all headers | View raw

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/

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Postgres scalability numbers Krishna Murthy Nazare <nkrishnamurthy@gmail.com> - 2017-03-26 23:14 -0700
  Re: Postgres scalability numbers Robert Klemme <shortcutter@googlemail.com> - 2017-03-27 20:44 +0200
    Re: Postgres scalability numbers Krishna Murthy Nazare <nkrishnamurthy@gmail.com> - 2017-03-29 07:33 -0700

csiph-web