factor effecting performance of postgres

On 1/19/2017 12:46 PM, PAWAN SHARMA wrote:

I am new to postgres using OS: linux 7.2 and postgres
: postgresql-9.5.4-2.

what are the factor's affecting postgres performance? and to overcome
them.

* CPU speed,
* cpu core count (if you have significant concurrency),
* memory size,
* disk IO speed (especially small block random write ops/second for
insert/update intensive OLTP),
* database schema design,
* query design,
* administrator and developer knowledge.

in no particular order, any number of those can be critical depending on
the nature of your applications.

--
john r pierce, recycling bits in santa cruz

On 01/19/2017 12:46 PM, PAWAN SHARMA wrote:

Hello All,

Please stop cross-posting to more then one mailing list.

I am new to postgres using OS: linux 7.2 and postgres : postgresql-9.5.4-2.

what are the factor's affecting postgres performance? and to overcome them.

Please suggest..!

*-Pawan*

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general