pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedReduce the size of the archived-log directory
3+ messages / 2 participants
[nested] [flat]
* Reduce the size of the archived-log directory
@ 2013-03-28 06:08 Hoàng Thanh Toàn - DB <toanht@dtsc.com.vn>
0 siblings, 0 replies; 3+ messages in thread
From: Hoàng Thanh Toàn - DB @ 2013-03-28 06:08 UTC (permalink / raw)
To: pgsql-admin
Dear all,
Please help me.
Please show me how to reduce the size of the archived-log directory.
My postgres database only get 4gbyte but the archived-log directory reaches
several tens of gigabyte in one day.
please give me some advice.
Thanks a lot.
--
Best Regards,
Hoàng Thanh Toàn,
Dong Tien Service Corporation
4th Floor, 418 Tran Phu Street, Ward 7, District 5, Ho Chi Minh City
Mobile: 0908915195
Yahoo: hoangthanhtoan1704
^ permalink raw reply [nested|flat] 3+ messages in thread
* Reduce the size of the archived-log directory
@ 2013-03-28 06:10 Hoàng Thanh Toàn - DB <toanht@dtsc.com.vn>
0 siblings, 1 reply; 3+ messages in thread
From: Hoàng Thanh Toàn - DB @ 2013-03-28 06:10 UTC (permalink / raw)
To: pgsql-admin
Dear all,
Please help me.
Please show me how to reduce the size of the archived-log directory.
My postgres database only get 4gbyte but the archived-log directory reaches
several tens of gigabyte in one day.
please give me some advice.
Thanks a lot.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Reduce the size of the archived-log directory
@ 2013-03-28 07:12 Vasilis Ventirozos <v.ventirozos@gmail.com>
parent: Hoàng Thanh Toàn - DB <toanht@dtsc.com.vn>
0 siblings, 0 replies; 3+ messages in thread
From: Vasilis Ventirozos @ 2013-03-28 07:12 UTC (permalink / raw)
To: pgsql-admin
The size of your directory will increase by 16mb on every checkpoint (16Mb
or 5 mins) so, even if your DB is completely idle you will get 16Mb per 5
mins, make the calculations and you'll see the space you need per day.
Vasilis Ventirozos
On Thu, Mar 28, 2013 at 8:54 AM, Hoàng Thanh Toàn - DB
<toanht@dtsc.com.vn>wrote:
> Hello Vasilis,****
>
> Thanks for your reply,****
>
> I thinks your archiving is successful for transfering WAL segments.****
>
> archive_command = 'test ! -f /mnt/FRA/ArchivedLog/%f && cp %p
> /mnt/FRA/ArchivedLog/%f' # command to use to archive a
> logfile segment****
>
> You are right that I am archiving at a local disk, but what it shall
> affect the size of the archived WAL directory.****
>
> ** **
>
> ############################## postgresql.conf (standalone
> server)###########################################****
>
> # - Settings -****
>
> ** **
>
> wal_level = archive # minimal, archive, or
> hot_standby****
>
> # (change
> requires restart)****
>
> #fsync = on # turns forced
> synchronization on or off****
>
> #synchronous_commit = on # synchronization level; on, off,
> or local****
>
> #wal_sync_method = fsync # the default is the first option**
> **
>
> # supported by
> the operating system:****
>
> #
> open_datasync****
>
> # fdatasync
> (default on Linux)****
>
> # fsync****
>
> #
> fsync_writethrough****
>
> # open_sync*
> ***
>
> #full_page_writes = on # recover from
> partial page writes****
>
> #wal_buffers = -1 # min 32kB, -1 sets based
> on shared_buffers****
>
> # (change
> requires restart)****
>
> #wal_writer_delay = 200ms # 1-10000 milliseconds****
>
> ** **
>
> #commit_delay = 0 # range 0-100000, in
> microseconds****
>
> #commit_siblings = 5 # range 1-1000****
>
> # - Checkpoints -****
>
> ** **
>
> checkpoint_segments = 7 # in logfile segments, min 1,
> 16MB each****
>
> #checkpoint_timeout = 5min # range 30s-1h****
>
> #checkpoint_completion_target = 0.5 # checkpoint target
> duration, 0.0 - 1.0****
>
> #checkpoint_warning = 30s # 0 disables****
>
> ** **
>
> # - Archiving -****
>
> ** **
>
> archive_mode = on # allows archiving to be done****
>
> # (change requires restart)
> ****
>
> archive_command = 'test ! -f /mnt/FRA/ArchivedLog/%f && cp %p
> /mnt/FRA/ArchivedLog/%f' # command to use to archive a
> logfile segment****
>
> archive_timeout = 180 # force a logfile segment
> switch after this****
>
> # number of seconds; 0
> disables****
>
> # - Master Server -****
>
> ** **
>
> # These settings are ignored on a standby server****
>
> ** **
>
> #max_wal_senders = 0 # max number of walsender
> processes****
>
> # (change requires restart)
> ****
>
> #wal_sender_delay = 1s # walsender cycle time, 1-10000
> milliseconds****
>
> #wal_keep_segments = 0 # in logfile segments, 16MB each;
> 0 disables****
>
> #vacuum_defer_cleanup_age = 0 # number of xacts by which cleanup is
> delayed****
>
> #replication_timeout = 60s # in milliseconds; 0 disables****
>
> #synchronous_standby_names = '' # standby servers that provide sync rep
> ****
>
> # comma-separated list of
> application_name****
>
> # from standby(s); '*' =
> all****
>
> --****
>
> ** **
>
> *From:* Vasilis Ventirozos [mailto:v.ventirozos@gmail.com]
> *Sent:* Thursday, March 28, 2013 1:29 PM
> *To:* Hoàng Thanh Toàn - DB
> *Subject:* Re: [ADMIN] Reduce the size of the archived-log directory****
>
> ** **
>
> Hello,****
>
> its either your archiving is failing to transfer wal segments (check
> archiving_command) , or you are archiving at a local disk (you shouldnt,
> check archiving command) or you have an astronomical archive_keep_segments
> value****
>
> ** **
>
> ** **
>
> Vasilis Ventirozos****
>
> ** **
>
> ** **
>
> On Thu, Mar 28, 2013 at 8:10 AM, Hoàng Thanh Toàn - DB <toanht@dtsc.com.vn>
> wrote:****
>
> Dear all,****
>
> Please help me.****
>
> Please show me how to reduce the size of the archived-log directory.****
>
> My postgres database only get 4gbyte but the archived-log directory
> reaches several tens of gigabyte in one day.****
>
> please give me some advice.****
>
> Thanks a lot.****
>
> ****
>
> ****
>
> ** **
>
> ** **
>
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2013-03-28 07:12 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-03-28 06:08 Reduce the size of the archived-log directory Hoàng Thanh Toàn - DB <toanht@dtsc.com.vn>
2013-03-28 06:10 Reduce the size of the archived-log directory Hoàng Thanh Toàn - DB <toanht@dtsc.com.vn>
2013-03-28 07:12 ` Vasilis Ventirozos <v.ventirozos@gmail.com>
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