Changes between Version 49 and Version 50 of InstallationGuidelines/PostgreSQL


Ignore:
Timestamp:
11/15/11 15:15:02 (13 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • InstallationGuidelines/PostgreSQL

    v49 v50  
    3535NB Don't do remote access as 'postgres' - to do so means can't simply access psql via 'su postgres'
    3636
    37 
     37To log-in as user postgres (Debian/Ubuntu):
     38{{{
     39sudo su postgres
     40}}}
     41
     42== Tuning PostgreSQL ==
    3843Adjust postgresql.conf for performance relative to resources available (http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server)
    3944{{{
    … …  
    5863# Ideal is if all frequently accessed indexes and table rows can fit in here - this is often unrealistic
    5964# setting too high relative to system resources can be detrimental to the system.
    60 # At the high end this should be no more than 1/4 to 1/3 the available memory (ie that which is not being used by the OS or other processes).
     65# At the high end this should be 10-25% of available memory (ie that which is not being used by the OS or other processes).
    6166# Values suggested are quite conservative, so you can push them up a bit if there are resources available for it
    6267# but absolutely no more than 1/3 available memory.
    … …  
    6772
    6873# effective_cache_size = 128MB
     74# 75% of available memory
    6975# 512Mb system suggest starting at:
    7076effective_cache_size = 256MB
    … …  
    8793}}}
    8894
    89 Logging-in as user postgres (Ubuntu Users)
    90 {{{
    91 sudo su postgres
    92 }}}
    93 
     95== Install Support Tools ==
    9496(Optional) Install the Admin Pack for enhanced intrumentation:
    9597{{{