pgrust screenshot thumbnail

pgrust

pgrust gives you one PostgreSQL-compatible server for both transactions and fast analytics, with psql sessions, drivers, and ORMs working unchanged. Row storage or columnar: pick per table. The pgrcolumnar format keeps compressed column data with zone maps and background compaction, and still supports transactional writes, rollbacks, and WAL logging for crash recovery. Columnar tables accept B-tree, hash, GiST, SP-GiST, and GIN indexes. Updates and deletes are recorded as markers instead of rewriting stored data. The Gravity query engine runs DML with ON CONFLICT and RETURNING, triggers, cursors, PL/pgSQL, and COPY with Postgres semantics, and compiles query plans to machine code. A built-in scheduler lowers the priority of long-running queries, so heavy reports interfere less with quick lookups. One memory budget, sized from the machine, covers the buffer pool, columnar caches, and running queries; near the limit, pgrust cancels the statement using the most memory instead of letting the operating system kill the server. Extensions come bundled: pgvector, pg_cron, pg_stat_statements, pg_trgm, hstore, pgcrypto, and postgres_fdw. The Docker image mirrors the official postgres image's environment variables, init script folder, and data volume. A browser demo at pgrust.com/try runs queries before you install anything. It is beta software, so keep regular Postgres as the source of truth for critical data. Running on a dedicated VPS on RepoCloud with guaranteed CPU, RAM, and SSD, full root SSH access, and a browser serial console. AGPL-3.0 licensed.

Deploy