| 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: | Whole Thread | Raw Message | 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 |