| From: | Ian Lawrence Barwick <barwick(at)gmail(dot)com> |
|---|---|
| To: | "rjo_roy(at)yahoo(dot)com" <rjo_roy(at)yahoo(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Wals not recycling |
| Date: | 2018-12-20 12:53:38 |
| Message-ID: | CAB8KJ=g9EBtHPkQ0bN4hKXn5VV9deRUqo5YgnC5Kx+zhCi8Eyg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2018年12月20日(木) 21:18 Rijo Roy <rjo_roy(at)yahoo(dot)com>:
>
> Hi All,
>
> I am facing an issue with wal recycling in one of my Postgresql servers running ina rhel box and the PG version is 10. The issue is that wal files are not recycling at all. Please note that its a qa server and the load is quite high on it. It is running in no archive mode with fsync on, max_wal_size is 8GB with checkpoint_timeout of 5mins and default checkpoint_completion_target of 0.5. Could you please give me some pointers what could be wrong, if it is hardware that is problem here, how can I collect some facts about it so that 8 can take this matter with system guys.
> Average wal generation is approximately 9k per day
> I have enabled log_checkpoint in my server and I can see it says checkpoint complete: wrote ###buffers, 0 wal files added, 0 removed, 0 recycled,,,, LogCheckpointEnd
> I have no active replication slots in this database cluster.Also the wal_keep_segments is set to 0. Appreciate your help!
You say you have no *active* replication slots - does that imply you
have at least one *inactive* replication slot? If so, that will cause
WAL files to be retained indefinitely.
Regards
Ian Barwick
--
Ian Barwick http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ian Lawrence Barwick | 2018-12-20 12:55:40 | Re: PostgreSQL version compatibility with RHEL7.6 |
| Previous Message | Rijo Roy | 2018-12-20 12:17:56 | Wals not recycling |