How do I fix No space left on device error from postgres in docker

I’m trying to write a query that is going to be updating a lot of rows but I keep hitting

ERROR:  could not write to file "base/pgsql_tmp/pgsql_tmp441.1627": No space left on device

I imagine that this is because I don’t have enough space in my docker container but all of this is new to me so I’m not really sure if there is something obvious I’m missing. How would I go about seeing how much space I currently have and how would I increase it?

This is my docker compose file

version: "3"
services:
  db-15:
    image: postgres:15
    ports:
      - "55432:5432"
    volumes:
      - app-db-data:/var/lib/postgresql/data/pgdata
    environment:
      POSTGRES_HOST_AUTH_METHOD: "trust"
      PGDATA: "/var/lib/postgresql/data/pgdata"
      POSTGRES_USER: postgres
      POSTGRES_PASSWORD: mypassword
      POSTGRES_DB: postgres

  db-13:
    image: postgres:13
    ports:
      - "55433:5432"
    volumes:
      - app-db-data-13:/var/lib/postgresql/data/pgdata
    environment:
      POSTGRES_HOST_AUTH_METHOD: "trust"
      PGDATA: "/var/lib/postgresql/data/pgdata"
      POSTGRES_USER: postgres
      POSTGRES_PASSWORD: mypassword
      POSTGRES_DB: postgres

volumes:
  app-db-data:
  app-db-data-13: