Service · Consulting
PostgreSQL consulting: performance, migrations and operations, with measurements rather than opinions.
When the database gets slow, grows beyond plan, or has to be migrated, you want someone who reads an execution plan, measures before changing anything, and measures again afterwards. We work with your team, in English and Spanish.
It is for you if…
- Some queries take seconds and nobody knows why, or the problem only shows up in production.
- You are coming from SQL Server, MySQL, Oracle or a managed database and want to move to PostgreSQL without surprises.
- The database grew and the decisions about partitioning, indexes, vacuum or replicas can no longer be postponed.
- Your team wants to learn to run PostgreSQL well and needs someone alongside for a while.
What it includes
- 01
Performance
Slow queries, execution plans, missing or redundant indexes, statistics, memory and autovacuum configuration. Measured before and after.
- 02
Migration to PostgreSQL
From SQL Server, MySQL, Oracle, or between PostgreSQL versions. Schema, data, queries and the application; with a dress rehearsal before cutover.
- 03
Operations and availability
Backups and tested restores, replicas, failover, monitoring, major upgrades.
- 04
Schema design
Review of the data model: constraints, types, partitioning, what the database should guarantee and the application guarantees today.
- 05
Working alongside your team
Recurring hours to review changes, answer questions and decide with someone who knows the engine from the inside.
How we work
Tell us what is slow or what you want to migrate.
PostgreSQL version, where it runs, and what worries you. That is enough to set up the diagnosis.
Request consulting- 01
Measured diagnosis
What hurts, how much, and since when. We capture plans, statistics and real metrics before proposing anything.
- 02
A proposal with numbers
Every change with its expected effect and its risk. If there are several options, we compare them by measuring.
- 03
Apply and measure again
Applied in a test environment, measured, applied in production with a way back, measured again.
What you get
- Diagnosis report with measurements and execution plans
- Proposed changes with their measured effect
- Migration plan with a dress rehearsal, where it applies
- Working sessions with your team
So there are no surprises
- We take part in PostgreSQL development: when something is a limit of the engine and not of your database, we say so and, where it fits, take it to the community.
- Hourly, per project, or as monthly support. Quoted after the diagnosis. There is no public price.
Who does it
Manuel Reyes Bravo, Chilean software engineer: author of the 7 PostgreSQL extensions on this site (Apache-2.0, published on PGXN) and credited on commits in the PostgreSQL core, verifiable on git.postgresql.org. Works in English and Spanish.
Frequently asked questions
PostgreSQL consulting
Do you work with managed PostgreSQL (RDS, Aurora, Cloud SQL, Supabase)?
Yes. What changes is which parameters you can touch; the analysis of queries, indexes and schema is the same.
Can you help with a single slow query?
Yes. A bounded diagnosis fits in one session, with the execution plan in hand.
Which PostgreSQL versions do you handle?
The community-supported ones, and the new versions from before their release: part of our work happens in the development of the engine itself.
Do you do the whole migration or only advise?
Both. We prefer your team executes with us alongside, but we can do it ourselves if you have nobody to.
Related guides
See all services
- Service · Audit PostgreSQL security audit What every role, application and AI agent can touch in your database today. With the SQL evidence for every finding.
- Service · Rescue Rescue of AI-built apps It crashes, it is slow, or the AI can no longer fix it. Evidence-based diagnosis, stabilization, and code that can be continued.
- Service · Development Custom development Backends, APIs and systems with PostgreSQL as the core: data model, security, and AI connected to your data.
Let’s talk
Tell us what is slow or what you want to migrate.
PostgreSQL version, where it runs, and what worries you. That is enough to set up the diagnosis.
Request consulting