FAQ

How to tune PostgreSQL for best performance with IntelligenceCenter

FAQ ID:    FAQ2123
Version:    2.0
Status:    Published
Published date:    05/09/2012
Updated:    10/01/2013
 

Answer

PostgreSQL is the database application used by IntelligenceCenter. For best performance from IntelligenceCenter, PostgreSQL can be tuned to make the most of the resources available to it. You do this by editing the postgresql.conf file, which determines the amount of memory used for buffers, authentication time outs, and so on. This document should be used in conjunction with the server tuning guide.

The postgresql.conf file is located in the \PostgreSQL\8.x\Data folder. You can tune the following sections of the postgresql.conf file to get the best performance out of IntelligenceCenter:

1)      CONNECTIONS AND AUTHENTICATION

2)      RESOURCE USAGE (except WAL)

3)      RUNTIME STATISTICS

4)      QUERY TUNING

5)      AUTOVACUUM PARAMETERS

 

CONNECTIONS AND AUTHENTICATION

In this section change the following entries to the following:

max_connections = 350

authentication_timeout = 7min

 

RESOURCE USAGE (except WAL)

In this section change the following entries to the following:

shared_buffers = 256MB

temp_buffers = 32MB

max_prepared_transactions = 20

work_mem = 1024MB

maintenance_work_mem = 1024MB

 

QUERY TUNING

effective_cache_size = 2048MB

 

RUNTIME STATISTICS

track_counts = on

 

AUTOVACUUM PARAMETERS

autovacuum = on

 

After you make the changes, save the file and restart the server to implement the changes.


Rate this Page

Please take a moment to complete this form to help us better serve you.

Did this document help answer your question?
 
 
If you are finished providing feedback, please click the RATE CONTENT button. Otherwise, please add more detail in the following text box and then click RATE CONTENT.
 
 

Your response will be used to improve our document content.

Ask a Question