Re: Monitoring multixact members growth

On 8/19/22 12:52 AM, Vido Vlahinic wrote: > My goal here is to predict where multixact members are growing the > fastest so I can perform manual VACUUM FREEZE only on those tables > > (typically with multi-billion row count) when system is relatively > idle as opposed to just sit and wait for

Re: Monitoring multixact members growth

On Fri, Aug 19, 2022 at 8:40 AM Vido Vlahinic wrote: > However it is not quite clear to me how I can interpret results from above > and e.g. conclude: my_table accumulates x more multixact members since I > measured last. You can't. And not just because nobody got around to implementing it yet

Re: High Availability PostgresDB on K8s

Hi, Am Freitag, 19. August 2022, 17:09:35 CEST schrieb Marco Schmucki: > I want to run an HA-Postgres-DB on a Kubernetes cluster for testing purposes > (Proof of Concept). > > Do you have some links or documentation? We're usually using Bitnami's Helm charts [1], [2] to deploy PostgreSQL into

Re: recovery_command has precedence over phisical slots?

On Fri, 2022-08-19 at 16:54 +0200, Giovanni Biscontini wrote: > Hello everyone,  > I'm experiencing a behaviour I don't really understand if is a > misconfiguration or a wanted behaviour: > 1) I set up a primary server (a.k.a. db1) with and archive_command to a > storage > 2) I set up a replica

Re: High Availability PostgresDB on K8s

This may help - https://phoenixnap.com/kb/postgresql-kubernetes [https://phoenixnap.com/kb/wp-content/uploads/2021/08/how-to-deploy-postgresql-on-kubernetes.png] How to Deploy PostgreSQL on Kubernetes {Helm Chart or Manual Config} - Knowledge

High Availability PostgresDB on K8s

Hi all I want to run an HA-Postgres-DB on a Kubernetes cluster for testing purposes (Proof of Concept). Do you have some links or documentation? Many thanks for your feedback! Best regards, Marco

RE: Monitoring multixact members growth

Hello everyone, Is there a way to monitor multixact members growth per table ? There is this query: SELECT relname, relminmxid, mxid_age(relminmxid) AS age FROM pg_class WHERE relkind = 'r' AND relnamespace::regnamespace::text = 'public' ORDER BY 3 DESC However it is not quite clear to me how

Monitoring multixact members growth

Hello everyone, Is there a way to monitor multixact members growth per table ? There is this query: SELECT relname, relminmxid, mxid_age(relminmxid) AS age FROM pg_class WHERE relkind = 'r' AND relnamespace::regnamespace::text = 'public' ORDER BY 3 DESC However it is not quite clear to me how

recovery_command has precedence over phisical slots?

Hello everyone, I'm experiencing a behaviour I don't really understand if is a misconfiguration or a wanted behaviour: 1) I set up a primary server (a.k.a. db1) with and archive_command to a storage 2) I set up a replica (a.k.a. db2) that created a slot named as slot_2 and that has the

Re:Re:Re: Different execution plan between PostgreSQL 8.2 and 12.5

Dear Adrian, Sorry, there is an error in the email just replied, the version of PostgreSQL is wrong. PostgreSQL 8.4 → PostgreSQL 8.2 At 2022-08-19 12:42:54, "gzh" wrote: Dear Adrian, I appreciate your reply. Your reply gave me a new idea, it should not be the problem that the