Skip to main content

All Questions

Tagged with
Filter by
Sorted by
Tagged with
0 votes
0 answers
26 views

PostgreSQL Table Size Increased After Aborted VACUUM FULL—Unable to Reclaim Space [duplicate]

I am using PostgreSQL deployed in a Kubernetes cluster, and I connect to it using pgAdmin via port forwarding. I recently ran the maintenance toolkit in pgAdmin on my Prefect database. During this ...
Avenash Sharma's user avatar
0 votes
0 answers
48 views

Prefect Database high Lock time

I am running prefect 2.7.1 on Kubernetes on AWS EKS. I am using AWS RDS m7g.4xlarge as the database for prefect I am able to see spike in the wait time in the performance monitoring of the RDS going ...
deenbandhu's user avatar
1 vote
1 answer
841 views

Cleaning ~/.prefect/pg_data/ when using Prefect

I'm using Prefect to automatize my flows (python scripts). Once running, some data get persisted to a postgresql database, problem, the size of pg_data gets rapidely out of hands (~20Gb) and I was ...
ChisActi's user avatar
2 votes
1 answer
1k views

About managing logs of prefect workflow

I am using prefect workflow for business applications. I have a question about logs stored in postgresql. If daily logs are kept stored on the postgresql server, the amount of data will be enormous. ...
Shinya Takahashi's user avatar