# A2/A3/A5 — docmost seeded on 9202, measured on a COPY of its datadir (2026-09-25T10:25:58Z)
datadir size: 65.5M
A3 counts (old engine): 0.49s, 48 tables, 62 rows total
db:docmost owner=docmost enc=UTF8 coll=en_US.utf8
db:postgres owner=docmost enc=UTF8 coll=en_US.utf8
role:docmost super=true login=true pw=true
ext:docmost:pg_trgm
ext:docmost:plpgsql
ext:docmost:unaccent
A2 pg_dumpall: 0.59s, 132184 B, tail: -- PostgreSQL database dump complete
A2 pg_dump --no-owner --no-privileges docmost: 0.27s, 123545 B
what pg_dumpall carries that the per-db dump does not:
      1 CREATE ROLE docmost;
      1 CREATE DATABASE docmost WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE_PROVIDER = libc LOCALE = 'en_US.utf8';
      1 ALTER TABLE public.workspaces OWNER TO docmost;
      1 ALTER TABLE public.workspace_invitations OWNER TO docmost;
      1 ALTER TABLE public.watchers OWNER TO docmost;
      1 ALTER TABLE public.users OWNER TO docmost;
      1 ALTER TABLE public.user_tokens OWNER TO docmost;
      1 ALTER TABLE public.user_sessions OWNER TO docmost;
      1 ALTER TABLE public.user_mfa OWNER TO docmost;
      1 ALTER TABLE public.templates OWNER TO docmost;
      1 ALTER TABLE public.spaces OWNER TO docmost;
      1 ALTER TABLE public.space_members OWNER TO docmost;
## route dumpall: new engine init 2.64s, load 1.76s, counts 0.48s, PG_VERSION=18, load errors=2
      1 ERROR:  database "docmost" already exists
      1 ERROR:  role "docmost" already exists
   dbs/owners/extensions/row counts: IDENTICAL
   roles before: role:docmost super=true login=true pw=true 
   roles after:  role:docmost super=true login=true pw=true 
   datadir after: 49.9M
## route pgdump: new engine init 2.64s, load 1.44s, counts 0.49s, PG_VERSION=18, load errors=0
   dbs/owners/extensions/row counts: IDENTICAL
   roles before: role:docmost super=true login=true pw=true 
   roles after:  role:docmost super=true login=true pw=true 
   datadir after: 49.8M
A5 space: copy of the old datadir = 68707765 B; dump = 132184 B; new datadir = 52271397 B
