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@xxxxxxxxxxxxxxx> wrote: > Do check a previous thread: > http://www.mail-archive.com/pgsql-general@xxxxxxxxxxxxxx/msg149691.html > > On Sun, Aug 29, 2010 at 10:32 PM, Dario Beraldi <dario.beraldi@xxxxxxxx> > 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@xxxxxxxxxxxxxx) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general > > -- To understand recursion, one must first understand recursion. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
