Skip to content

PostgreSQL: Buffer cache hit ratio #1283

Closed as duplicate
Closed as duplicate

Description

@KaeTuuN

Steps to reproduce

  1. Open <domain>/settings/admin/serverinfo#database
  2. See the Error below
  3. Stop all Containers via AIO Frontend
  4. Edit postgresql.conf in /<path>/<to>/<docker-volume>/nextcloud_aio_database/_data/postgresql.conf
    by changing shared_buffers = 256MB to shared_buffers = 1G
  5. Start all Containers
  6. Checking postgresql.conf again and seeing shared_buffers value is at 256MB again
Bildschirmfoto vom 2026-11-13 15-10-24

Expected behavior

The Value should stay at 1G and the error Message (hopefully) is gone.

Actual behavior

Described in Step 6

Other information

Host OS

Debian 13

Output of sudo docker info

 Version:    29.9.3
 Context:    default
 Debug Mode: false
 Plugins:
  buildx: Docker Buildx (Docker Inc.)
    Version:  v0.39.0
    Path:     /usr/libexec/docker/cli-plugins/docker-buildx
  compose: Docker Compose (Docker Inc.)
    Version:  v5.7.1
    Path:     /usr/libexec/docker/cli-plugins/docker-compose

Server:
 Containers: <deleted>
  Running: <deleted>
  Paused: <deleted>
  Stopped: <deleted>
 Images: <deleted>
 Server Version: 29.9.3
 Storage Driver: overlay2
  Backing Filesystem: extfs
  Supports d_type: true
  Using metacopy: false
  Native Overlay Diff: true
  userxattr: false
 Logging Driver: json-file
 Cgroup Driver: systemd
 Cgroup Version: 2
 Plugins:
  Volume: local
  Network: bridge host ipvlan macvlan null overlay
  Log: awslogs fluentd gcplogs gelf journald json-file local splunk syslog
 CDI spec directories:
  /etc/cdi
  /var/run/cdi
 Swarm: inactive
 Runtimes: io.containerd.runc.v2 runc
 Default Runtime: runc
 Init Binary: docker-init
 containerd version: b7a25261e029d68978bbf290df0a62fc819b3c51
 runc version: v1.5.3-0-g46365c62
 init version: de40ad0
 Security Options:
  apparmor
   Profile: default
  seccomp
   Profile: builtin
  cgroupns
 Kernel Version: 7.1.8+deb13-amd64
 Operating System: Debian GNU/Linux 13 (trixie)
 OSType: linux
 Architecture: x86_64
 CPUs: <deleted>
 Total Memory: <deleted>
 Name: <deleted>
 ID: <deleted>
 Docker Root Dir: <deleted>
 Debug Mode: false
 Experimental: false
 Insecure Registries:
  <deleted>
 Live Restore Enabled: false
 Firewall Backend: iptables
  EnableUserlandProxy: true
  UserlandProxyPath: /usr/bin/docker-proxy

Docker run command or docker-compose file that you used

Nothing of use here

Output of sudo docker logs nextcloud-aio-mastercontainer

Nothing of use here

Output of sudo docker inspect nextcloud-aio-mastercontainer

Some sensitive information here. Please tell me, if you need any specific info.

Output of sudo docker ps -a | grep nextcloud

44b391c1ceb8   ghcr.io/nextcloud-releases/aio-nextcloud:latest             "/start.sh dinit --s…"   32 minutes ago   Up 32 minutes (healthy)     9000/tcp                                                                                                                                               nextcloud-aio-nextcloud
410bf056f754   ghcr.io/nextcloud-releases/aio-docker-socket-proxy:latest   "/start.sh"              32 minutes ago   Up 32 minutes (healthy)                                                                                                                                                            nextcloud-aio-docker-socket-proxy
944b6913d266   ghcr.io/nextcloud-releases/aio-imaginary:latest             "/start.sh"              32 minutes ago   Up 32 minutes (healthy)                                                                                                                                                            nextcloud-aio-imaginary
29453ef9594a   ghcr.io/nextcloud-releases/aio-talk-recording:latest        "/start.sh python -m…"   32 minutes ago   Up 32 minutes (healthy)                                                                                                                                                            nextcloud-aio-talk-recording
8e16fbe9b021   ghcr.io/nextcloud-releases/aio-fulltextsearch:latest        "/start.sh"              32 minutes ago   Up 32 minutes (healthy)     9200/tcp, 9300/tcp                                                                                                                                     nextcloud-aio-fulltextsearch
0892fa484453   ghcr.io/nextcloud-releases/aio-clamav:latest                "/start.sh dinit --s…"   32 minutes ago   Up 32 minutes (healthy)                                                                                                                                                            nextcloud-aio-clamav
4f84ba6106d7   ghcr.io/nextcloud-releases/aio-redis:latest                 "/start.sh"              32 minutes ago   Up 32 minutes (healthy)     6379/tcp                                                                                                                                               nextcloud-aio-redis
d9a05d0dbe77   ghcr.io/nextcloud-releases/aio-postgresql:latest            "/start.sh"              32 minutes ago   Up 32 minutes (healthy)     5432/tcp                                                                                                                                               nextcloud-aio-database
091a232f3167   ghcr.io/nextcloud-releases/aio-whiteboard:latest            "/start.sh"              32 minutes ago   Up 32 minutes (healthy)     3002/tcp                                                                                                                                               nextcloud-aio-whiteboard
97f35126ff96   ghcr.io/nextcloud-releases/aio-notify-push:latest           "/start.sh"              32 minutes ago   Up 32 minutes (healthy)                                                                                                                                                            nextcloud-aio-notify-push
fcf2ee5f339d   ghcr.io/nextcloud-releases/aio-talk:latest                  "/start.sh dinit --s…"   32 minutes ago   Up 32 minutes (healthy)     0.0.0.0:3478->3478/tcp, 0.0.0.0:3478->3478/udp, [::]:3478->3478/tcp, [::]:3478->3478/udp                                                               nextcloud-aio-talk
02d74354520a   ghcr.io/nextcloud-releases/aio-collabora:latest             "/usr/bin/coolwsd --…"   32 minutes ago   Up 32 minutes (healthy)     9980/tcp                                                                                                                                               nextcloud-aio-collabora
843073b91e56   ghcr.io/docjyj/aio-local-ai-vulkan:v1                       "/entrypoint.sh"         32 minutes ago   Up 32 minutes (healthy)     8080/tcp, 127.0.0.1:10078->10078/tcp                                                                                                                   nextcloud-aio-local-ai
d5c19501cb6d   ghcr.io/nextcloud-releases/aio-borgbackup:latest            "/start.sh"              14 hours ago     Exited (0) 13 hours ago                                                                                                                                                            nextcloud-aio-borgbackup
c40dd2d887a8   ghcr.io/nextcloud-releases/aio-watchtower:latest            "/start.sh"              2 days ago       Exited (0) 2 days ago                                                                                                                                                              nextcloud-aio-watchtower
899f02e757c3   ghcr.io/nextcloud-releases/all-in-one:latest                "/start.sh"              3 days ago       Up 19 hours (healthy)       80/tcp, 8443/tcp, 9000/tcp, 0.0.0.0:8088->8080/tcp, [::]:8088->8080/tcp                                                                                nextcloud-aio-mastercontainer
990b6a3f5fce   ghcr.io/nextcloud/llm2:2.8.0                                "/start.sh poetry ru…"   3 weeks ago      Up 19 hours (healthy)                                                                                                                                                              nc_app_llm2
67ff66b05e53   ghcr.io/nextcloud-releases/context_chat_backend:5.5.0       "supervisord -c /etc…"   3 weeks ago      Up 19 hours                                                                                                                                                                        nc_app_context_chat_backend

Other valuable info

Activity

  1. kesselb commented on Nov 17, 2026

    @kesselb
    Collaborator

    Thanks for the report! The problem here is the check, not your configuration: pg.cache_hit_ratio uses a fixed limit of 99%, which is too strict for many instances. That is already tracked in #1231, so I'm closing this as a duplicate to keep the discussion in one place.

    On AIO, the database container manages postgresql.conf itself, so please don't change it by hand; as you noticed, the changes are reset on each start.

    Assisted-by: ClaudeCode:claude-opus-5-5

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions