pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: erik@norvelle.net
To: pgsql-performance@postgresql.org
Subject: Re: Update performance ... Recommended configuration changes?
Date: Wed,  3 Dec 2003 15:22:27 -0600
Message-ID: <1070486547.3fce54135a65d@69.49.227.23> (raw)


Thanks to Greg Stark, Tom Lane and Stephan Szabo for their advice on 
rewriting my query... the revised query plan claims it should only take 
about half the time my original query did.

Now for a somewhat different question:  How might I improve my DB 
performance by adjusting the various parameters in postgresql.conf and 
kernel config?  Again, TKA.

Here's what I've currently got (hardware, kernel config. and 
postgresql.conf)

Hardware: Mac iBook, G3 900Mhz, 640MB memory (This is my research machine :p 
)
OS:  OS X 10.2.6
Postgresql version: 7.3.2
Kernel Config:
    sysctl -w kern.sysv.shmmax=4194304
    sysctl -w kern.sysv.shmmin=1
    sysctl -w kern.sysv.shmmni=32
    sysctl -w kern.sysv.shmseg=8
    sysctl -w kern.sysv.shmall=1024

========================= Snip of postgresql.conf =================

#
#   Shared Memory Size
#
shared_buffers = 128        # min max_connections*2 or 16, 8KB each
max_fsm_relations = 2000    # min 10, fsm is free space map, ~40 bytes
max_fsm_pages = 20000       # min 1000, fsm is free space map, ~6 bytes
max_locks_per_transaction = 128 # min 10
wal_buffers = 16        # min 4, typically 8KB each
#
#   Non-shared Memory Sizes
#
sort_mem = 65535        # min 64, size in KB
vacuum_mem = 8192       # min 1024, size in KB

#
#   Write-ahead log (WAL)
#
#checkpoint_segments = 3    # in logfile segments, min 1, 16MB each
#checkpoint_timeout = 300   # range 30-3600, in seconds
#
#commit_delay = 0       # range 0-100000, in microseconds
#commit_siblings = 5        # range 1-1000
#
fsync = false
#wal_sync_method = fsync    # the default varies across platforms:
#               # fsync, fdatasync, open_sync, or open_datasync
#wal_debug = 0          # range 0-16

========================== End Snip =======================

Saludos,
Erik Norvelle





view thread (2+ messages)  latest in thread

Message-ID: <1070486547.3fce54135a65d@69.49.227.23>
Permalink:  ../1070486547.3fce54135a65d@69.49.227.23/
Also on:    postgresql.org/message-id/1070486547.3fce54135a65d@69.49.227.23

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: erik@norvelle.net
  Subject: Re: Update performance ... Recommended configuration changes?
  In-Reply-To: <1070486547.3fce54135a65d@69.49.227.23>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox