Skip to main content

Tuning postgresql for better performance - ADempiere ERP

PostgreSQL is a highly customizable relational database management system (RDBMS) with a dazzling array of configuration options. The postgresql.conf file is located in the \PostgreSQL\9.x\Data folder. You can tune the following sections of the postgresql.conf file to get the best performance.
 
 
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 : PG Backends that need to access tables first look for needed blocks in this cache. If they are already there, they can continue processing right away. The change can be made with a postmaster command-line flag or by changing the value of shared_buffers
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

You can also configure the logging details. A detailed description is available here. After you make the changes, save the file and restart the server to implement the changes.

 Find the best configuration for your resources. 
The following links may be helpful for better tuning

Labels:

Popular posts from this blog

Installation of Adempiere ERP on Windows

              This installation instruction is intended for initial installations where the database, application server and client all run on the same machine. For more complex installations, see   Installation Steps . An installation can take as little as 15 or 20 minutes if you start with the required downloads and do everything correctly. Other alternatives you might want to investigate are the   Windows Installer   or VMWare/VirtualBox AVA packages. However, the following method will give you much more control over the installation including upgrades with the latest patches and scripts. Before you begin, download each of the following packages: §   Java SE Development Kit   - Get the latest from   http://java.sun.com/javase/downloads/index.jsp . You only need the   JDK   without JavaFX, EE or NetBeans bundles. §   Postgre SQL   - Get the latest Windows install from   http://www.postgresql.org/download/windows . §   ADempiere Latest Release   - Download the latest Ad
Read more

The best Open Source ERP for Small and Medium Enterprises 2021

  The 'Free ERP' refers to items that are provided by a solution provider at no charge. These are typically stripped-down versions of the expert or business editions, with simple features such as report generation and data visualization. These are typically stripped-down versions of the expert or business editions, with simple features such as report generation and data visualization. Commercially free ERP tools usually have less features than their open source counterparts, but they can be a great way to get more than a free trial if you're already interested in the product.  Enterprise Resource Planning (ERP) Software Systems Enterprise Resource Planning software is a scalable software framework that integrates the various functional areas of a company's business processes. Certain core software elements, such as modules, concentrate on various main business areas within the enterprise. The modules are chosen by organizations based on their business needs. Integrated
Read more