Re: postgres.conf settings

Do check a previous thread:
http://www.mail-archive.com/pgsql-general(at)postgresql(dot)org/msg149691.html

On Sun, Aug 29, 2010 at 10:32 PM, Dario Beraldi <dario(dot)beraldi(at)ed(dot)ac(dot)uk>wrote:

> Hello,
>
> I'm trying to tune the parameters in postgres.conf to improve the
> performance of my database (where performance = 'make queries run faster').
> I would be very grateful if you could give me some comments about my choice
> of configuration settings below (did I do anything very silly? Am I missing
> something relevant?).
>
> This my situation:
>
> 1. I installed postgresql (8.4) on my own machine to manage my own data. So
> I'm its only user. Queries are not complicated but should handle tables with
> (tens of) millions of rows.
> 2. Hardware: Laptop (DELL Latitude E6500) with 3.48 GB of RAM; Intel Core 2
> Duo Mobile Processor P8600 2.40 GHz; running Windows XP. 160 GB hard disk (+
> an external one of 640 GB).
> 3. Size of database: The /data directory is c.ca 37 GB, 88 tables in the
> main schema.
> 4. Raw data is backed-up elsewhere so I'm not terribly worried about risks
> of losing data.
>
> And these are the entries in postgres.conf that I changed from default
> (after reading some literature/docs):
>
> max_connections = 20 # Default was 100
> shared_buffers = 512MB # min 128kB # Default was 32MB
> work_mem = 256MB # min 64kB default was 1MB
> wal_buffers = 1MB # min 32kB default was 64kb
> checkpoint_segments = 30 # in logfile segments, min 1, 16MB each;
> default was 3
> checkpoint_timeout = 30min # range 30s-1h; default was 3
> effective_cache_size = 1GB # Default 128MB
>
>
> I understand that tuning is a very database specific issue, but even some
> general pointers would help me...
>
> Many thanks!
>
> Dario
>
> --
>
> Dr. Dario Beraldi
> Institute of Evolutionary Biology
> University of Edinburgh
> West Mains Road
> Edinburgh EH9 3JT
> Scotland, UK
>
>
> --
> The University of Edinburgh is a charitable body, registered in
> Scotland, with registration number SC005336.
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>