Re: postgres.conf settings

And don't forge the wiki!

http://wiki.postgresql.org/wiki/Performance_Optimization

On Sun, Aug 29, 2010 at 12:14 PM, Sandeep Srinivasa <sss(at)clearsenses(dot)com> wrote:
> 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
>
>

--
To understand recursion, one must first understand recursion.