PDA

View Full Version : tuning postgres



holepunch
10-28-2008, 09:35 PM
This method requires PostgreSQL 8.3.x.

Go Start->Programs->PostgreSQL 8.3 and look for "Application Stack Builder". If listed, please jump to step 10.
Uninstall PostgreSQL via the Windows control panel (your data will be preserved)
(Vista users only) Make sure that User Account Control is disabled.
Start->Run, 'cmd' -> OK. At the command prompt type "net user postgres /delete" (no quotes) and hit enter.
Download the latest version of PostgreSQL 8.3.x from the PostgreSQL website. (Choose the latest version -> select 'win32' -> select 'postgresql-8.3.x.zip' -> click either http or ftp under your country's flag)
After download has completed, double click the file to open then extract the contents of the downloaded zip file.
Double click and run 'postgresql-8.3.msi' to manually re-install PostgreSQL 8.3.x
When you get to the screen to "Initialize your database", uncheck the box to skip this step. (This is not needed since your data directory is already configured and in tact from the previous installation)
At the end of the installation...
Launch the "Application Stack Builder"

Select your PostgreSQL Database Server and click 'Next'.
Expand "AddOns" and check "EnterpriseDB Tuning Wizard
Download the tuning wizard by selecting your country and continuing
Continue through the end of installation and ...
Launch the EnterpriseDB Tuning Wizard
Select your PostgreSQL Database server and click 'Next'
Under "Server Utilization" select "Mixed" and click 'Next'.
Continue through the installation of the tuning wizard
PostgreSQL memory usage has now been configured specifically for your computer's specifications and performance should be improved greatly.

FacePlant the Felt
10-29-2008, 12:54 AM
Pure goodness! :D

THANKS