Not Every Odoo App Scales the Same: Workers, PostgreSQL, Files, and Jobs

Not Every Odoo App Scales the Same: Workers, PostgreSQL, Files, and Jobs

The direct recommendation: Profile Odoo by business journey. Tune HTTP workers only after separating database waits, report CPU, cron queues, Live Chat/WebSocket traffic, attachment delivery, external calls, and locking behavior.

This article does not declare one provider universally best or invent a capacity or cost number. It gives you a reviewable method and requires measurement against the real workload. Primary sources were checked on 2026-08-28. Google Cloud comparisons are explicitly research-based, not presented as first-hand operating experience.

The decision in one minute

  • Website browsing is read-heavy and cache-sensitive; checkout adds sessions, stock, payment, and idempotency.
  • POS requires offline and reconnection tests, peripheral behavior, and safe order replay, not only browser throughput.
  • Accounting, inventory, and manufacturing concentrate correctness around posting, valuation, reservations, replenishment, and locks.
  • Large PDFs and exports can consume worker time and memory; move predictable long work into controlled jobs where appropriate.
  • Live Chat uses the gevent/WebSocket path documented by Odoo and must be tested separately from ordinary HTTP.

If the team cannot answer these points, the missing component is not another cloud service. The operating contract is incomplete. Write the assumptions, separate sourced facts from calculations, and identify what will be measured before purchase or release.

Reusable artifact

AreaDecisionAcceptance evidence
Website/eCommerceBrowse, search, cart, checkoutp95, errors, payment idempotency
POSOffline, reconnect, order sync, devicesNo duplicate or lost order
AccountingPost, reconcile, close, reportCorrect totals, locks, query time
Inventory/MRPReserve, move, value, planContention and queue age
Cron/reportsScheduled jobs and exportsDuration, overlap, memory
Attachments/Live ChatFilestore and WebSocketThroughput, recovery, connection stability

Put this matrix in the architecture decision or implementation ticket. Any row without an owner or acceptance evidence is deferred risk.

How to use the artifact

1. Website/eCommerce

The proposed decision is: Browse, search, cart, checkout, p95, errors, payment idempotency. Do not copy that value without context. Record its input source, environment, owner, and review date. Turn it into a repeatable check before and after release, including the wrong state the system must reject. Reopen the decision when data shape, region, traffic pattern, or ownership changes instead of assuming the previous setting remains safe.

2. POS

The proposed decision is: Offline, reconnect, order sync, devices, No duplicate or lost order. Do not copy that value without context. Record its input source, environment, owner, and review date. Turn it into a repeatable check before and after release, including the wrong state the system must reject. Reopen the decision when data shape, region, traffic pattern, or ownership changes instead of assuming the previous setting remains safe.

3. Accounting

The proposed decision is: Post, reconcile, close, report, Correct totals, locks, query time. Do not copy that value without context. Record its input source, environment, owner, and review date. Turn it into a repeatable check before and after release, including the wrong state the system must reject. Reopen the decision when data shape, region, traffic pattern, or ownership changes instead of assuming the previous setting remains safe.

4. Inventory/MRP

The proposed decision is: Reserve, move, value, plan, Contention and queue age. Do not copy that value without context. Record its input source, environment, owner, and review date. Turn it into a repeatable check before and after release, including the wrong state the system must reject. Reopen the decision when data shape, region, traffic pattern, or ownership changes instead of assuming the previous setting remains safe.

5. Cron/reports

The proposed decision is: Scheduled jobs and exports, Duration, overlap, memory. Do not copy that value without context. Record its input source, environment, owner, and review date. Turn it into a repeatable check before and after release, including the wrong state the system must reject. Reopen the decision when data shape, region, traffic pattern, or ownership changes instead of assuming the previous setting remains safe.

6. Attachments/Live Chat

The proposed decision is: Filestore and WebSocket, Throughput, recovery, connection stability. Do not copy that value without context. Record its input source, environment, owner, and review date. Turn it into a repeatable check before and after release, including the wrong state the system must reject. Reopen the decision when data shape, region, traffic pattern, or ownership changes instead of assuming the previous setting remains safe.

Implementation sequence

  1. Website browsing is read-heavy and cache-sensitive; checkout adds sessions, stock, payment, and idempotency. Start in a non-production environment and make step 1 produce a reviewable configuration, artifact, or metric.
  2. POS requires offline and reconnection tests, peripheral behavior, and safe order replay, not only browser throughput. Start in a non-production environment and make step 2 produce a reviewable configuration, artifact, or metric.
  3. Accounting, inventory, and manufacturing concentrate correctness around posting, valuation, reservations, replenishment, and locks. Start in a non-production environment and make step 3 produce a reviewable configuration, artifact, or metric.
  4. Large PDFs and exports can consume worker time and memory; move predictable long work into controlled jobs where appropriate. Start in a non-production environment and make step 4 produce a reviewable configuration, artifact, or metric.
  5. Live Chat uses the gevent/WebSocket path documented by Odoo and must be tested separately from ordinary HTTP. Start in a non-production environment and make step 5 produce a reviewable configuration, artifact, or metric.

Do not copy configuration between environments by hand. Version the policy, infrastructure, and release path where the service allows it, and keep production secrets out of the build. Another operator should be able to reproduce the path from the repository and runbook without hidden knowledge.

The DevOps and developer handoff contract

Handoff begins with an executable request: which commit or digest, which non-secret variables, which secret names and owners without copying values into the ticket, which health check, which migration, and what behavior is acceptable when a dependency fails? The developer supplies a local or test-environment run path, a safe configuration example, critical-journey tests, and the change’s data and backward-compatibility impact.

DevOps returns the environment address, permission boundary, log and dashboard locations, retention period, and deploy and rollback paths. Before approval, both sides name the release observer, decision window, and statistical threshold that aborts a canary or restores the previous artifact. After deployment, a message saying “done” is insufficient. Attach the deployed digest, timestamp, smoke result, public route, migration state, and any accepted deviation with a follow-up ticket. This contract prevents configuration failure from becoming an unowned gap between teams.

Failure modes to design tests around

Multiplying workers from a rule of thumb without measuring CPU, memory, PostgreSQL connections, and response time.

Do not approve this decision until an owner, environment, and pass threshold are named. Record the configuration, artifact digest, or log query that proves it, then add a deliberate failure test showing that the control rejects the wrong state. This turns advice into an operating contract shared by developers, DevOps, and security reviewers.

Sharing a local filestore across replaceable instances without durable synchronization.

Do not approve this decision until an owner, environment, and pass threshold are named. Record the configuration, artifact digest, or log query that proves it, then add a deliberate failure test showing that the control rejects the wrong state. This turns advice into an operating contract shared by developers, DevOps, and security reviewers.

Letting cron jobs overlap until they compete with interactive users.

Do not approve this decision until an owner, environment, and pass threshold are named. Record the configuration, artifact digest, or log query that proves it, then add a deliberate failure test showing that the control rejects the wrong state. This turns advice into an operating contract shared by developers, DevOps, and security reviewers.

Benchmarking demo data that has none of the production row counts, attachments, rules, or custom modules.

Do not approve this decision until an owner, environment, and pass threshold are named. Record the configuration, artifact digest, or log query that proves it, then add a deliberate failure test showing that the control rejects the wrong state. This turns advice into an operating contract shared by developers, DevOps, and security reviewers.

Testing and release gates

Build a small matrix that links every risk to a test, owner, and evidence. Test the happy path, then test the expected denial or failure. Keep source success separate from build success, provider deployment separate from public-route response, and add data integrity and queue age to health checks for stateful systems.

Run deterministic checks in CI, environment and migration checks in CD, then verify the critical journey at the real deployed URL. Define an automatic abort threshold for error rate, p95 latency, or dependency failure. Retain the previous artifact and a data-recovery procedure. Success is readable evidence, not a green indicator by itself.

Cost without a marketing number

Model compute, storage, requests, transfer, logs, backups, keys, support, failure headroom, and engineering time. Use the actual region’s price on the decision date, then enable budget and anomaly alerts. A saving that removes failure capacity or extends the recovery objective needs explicit approval.

The safest optimization is deleting an unneeded resource or measurably reducing origin work. Reservations and long commitments come after the workload stabilizes. Give every line item a unit, review owner, and action when it crosses its threshold.

Field note from operations

The reusable lesson is that repository source, built artifact, provider state, browser response, and data integrity are different evidence states. Incidents often last longer because one green step is treated as proof that the whole chain succeeded. Capture timestamp, identity, route, and effective configuration before widening access or changing several layers at once.

This is an anonymized operating lesson, not a client outcome or benchmark. Its practical value is the procedure: change one reversible thing, watch the expected signal, and update the timeline.

Practical next steps

  1. Copy the artifact above and fill it with system inputs and owners, not a sales forecast.
  2. Select the two riskiest assumptions and run a failure and recovery test in non-production.
  3. Record the decision, alternatives, cost model, acceptance evidence, and review date.
  4. Continue through the DevOps and cloud series according to the next gap in your operating model.

If you need an evidence-led architecture or delivery review, start with a small scope through the web and application development service that names the risks and proof before a larger commitment.

Continue the series

Use these links as a learning path, but validate every decision against the actual system.

Sources and review date

Last reviewed: 2026-08-28. Recheck pricing, quotas, and regional feature availability immediately before implementation.