CloudNative-PG in the Homelab with Longhorn

Who has tried running Postgres in Kubernetes? What is your take on managed services like RDS vs running self-hosted databases in K8s?