Обсуждение: [GENERAL] factor effecting performance of postgres

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