title: How to increase the performance of PostgreSQL?
body: <p>I have a query to be executed in PostgreSQL, which  gives nearly 1,00,0000 records and is taking too much time to execute.</p>
  
  <p>The server is installed in Ubuntu having 16 GB RAM. We have indexed the query to increase the performance and still taking time.
  Also I tried by changing some parameters like work_mem and effective_cache_size but there is no reasonable changes. </p>
  
  <p>Can anyone suggest a suitable values that  can be given for the performance related parameters in PostgreSQL for 16 GB RAM Ubuntu machine. </p>