Thread: [GENERAL] factor effecting performance of postgres
Hello All,
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
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