How to tune PostgreSQL for best performance with IntelligenceCenter


<< Back to Knowledge Search

Solution

Overview

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.

Cause
Resolution
Workaround
Additional Information
Bug Number
InQuira Doc IdFAQ2123
Attachment

Article Feedback

Hide Properties
First Published      10/01/2014
Last Modified      10/01/2014
Last Published      10/01/2014
Article Audience
Product      IntelligenceCenter 3.1, IntelligenceCenter 3.2
Article Number      000011467
Summary     
Was this helpful?
Comments:
 
Previous MonthNext Month
SunMonTueWedThuFriSat