On Wed, May 20, 2015 at 4:12 PM, Sachin Srivastava
wrote:
> Dear Venkata,
>
> I have not set this parameter "archive_timeout"
>
> I think that is also the reason.
>
> What value I'll assign to this parameter if my *Checkpoint_segments= 200 *and
> *checkpoint_timeout= 5min, *kindly confirm.
>
>
Be
(I'm not going to try to fix the top-posting)
I've seen what I think you're describing on several occasions.
What we basically discovered is very simple: disks have a top speed and
you can't exceed it.
If I understand you correctly, you see the # of wal segments grow very
large during and shortl
--
> "MY each WAL file is 16 MB."
---
Are you saying that you want WAL segments to be smaller? WAL file segments are
always the same size, which can be set with --with-WAL-segsize at build time
but not at runtime.
Regards
Mathew
Sent from my iPhone
> On May 20,
Hello,
>First: When I have given checkpoint segments=200 (As per my knowledge WAL
file should be generated >200*2+3=403 only) but why it’s generating too much
file. MY each WAL file is 16 MB.
The formula is
(2 + checkpoint_completion_target) * checkpoint_segments + 1
or
checkpoint_segments + wal
On Mon, May 18, 2015 at 9:44 PM, Sachin Srivastava
wrote:
> Hi,
>
>
>
> I have done below changes in my postgresql.conf.
>
>
>
> *Checkpoint_segments= 200*
>
> and
>
> *checkpoint_timeout= 5min*
>
>
>
> I am also doing archiving and below changes in my postgresql.conf.
>
>
>
> *Wal_level=archive*
Hi,
Any kind of slowness on your archive directory may cause the archiving
process fall behind thus accumulating segment files in your cluster's
pg_xlog directory.
I assume that you are on PostgreSQL 9.4. Could you please check your
archiver status by typing "select * from pg_catalog.pg_stat_arch
On 18/05/15 13:44, Sachin Srivastava wrote:
> But currently my pg_xlog size is 60 GB and there are 3740 WAL file in
> this folder and in Last week this was 400 GB(pg_xlog folder) and WAL
> file were approx. 3. Due to archiving pg_xlog folder size is
> decreasing now but it’s taking one week to
Hi,
I have done below changes in my postgresql.conf.
*Checkpoint_segments= 200*
and
*checkpoint_timeout= 5min*
I am also doing archiving and below changes in my postgresql.conf.
*Wal_level=archive*
*archive_command= cp %p /dbkup/momacpp_213_live/%f*
*archive_mode=on*
Achievin
