Re: Reg: Size difference
| От | Vinay Oli |
|---|---|
| Тема | Re: Reg: Size difference |
| Дата | |
| Msg-id | CACHNdrAYkT5zFPJH2U=ZQ_K4j+LgGpHjNx608UE9wFhFSnGSYg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Reg: Size difference (Aleksander Alekseev <aleksander@timescale.com>) |
| Список | pgsql-bugs |
Hi,
WAL and log files are being rotated properly. The issue is with a database named services_mfs. On the primary cluster, the services_mfs database is 104GB, but on the standby cluster, it is 216GB, even though both cluster are in sync. The standby database is only used in case of a crash, which is managed by a Patroni cluster with etcd.
Thanks,
Vinay Kumar
On Fri, 13 Sept 2024 at 16:08, Aleksander Alekseev <aleksander@timescale.com> wrote:
Hi,
> Could this be a bug? If so, has it been resolved in newer releases? If it is not a bug, how can this issue be fixed? Is there a solution or any supporting documentation available?
Hard to tell based on the provided information. Do you know which
files differ in particular? It could be as simple as a huge text log
file that was never rotated.
Also I'm a bit surprised that you use 15.0. I know several people who
believe that using the next major version of Postgres before the .2
minor release is not the best idea, and I can understand this point of
view. Postgres 15 had 8 updates in the past several years [1] with
multiple improvements / bug fixes in every one of them. You should
probably consider installing these updates.
[1]: https://www.postgresql.org/docs/release/15.8/
--
Best regards,
Aleksander Alekseev
В списке pgsql-bugs по дате отправления: