Re: [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