From: | paulo matadr <saddoness(at)yahoo(dot)com(dot)br> |
---|---|
To: | GENERAL <pgsql-general(at)postgresql(dot)org> |
Subject: | Archive files growth!!! |
Date: | 2008-11-13 20:59:05 |
Message-ID: | 122557.84422.qm@web52501.mail.re2.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
How the best way to controling fast growth in my Database.
atually my postgresql.conf have this:
# - Checkpoints -
checkpoint_segments = 15 # in logfile segments, min 1, 16MB each
checkpoint_timeout = 5min # range 30s-1h
#checkpoint_warning = 30s # 0 is off
# - Archiving -
archive_command = 'path' # command to use to archive a logfile segment
#archive_timeout = 0 # force a logfile segment switch after this
# many seconds; 0 is off
thnks
Novos endereços, o Yahoo! que você conhece. Crie um email novo com a sua cara @ymail.com ou @rocketmail.com.
http://br.new.mail.yahoo.com/addresses
From | Date | Subject | |
---|---|---|---|
Next Message | Phoenix Kiula | 2008-11-13 21:04:30 | Re: Tweaking PG (again) |
Previous Message | Grzegorz Jaśkiewicz | 2008-11-13 20:22:26 | Re: sort_mem param of postgresql.conf |