docker-compose-examples: Postgresql makes it slow

[fflorent]

Describe the current behavior

I have noticed the slowness issue when using docker-compose example with postgresql reported here: #773

Steps to reproduce

1. Go to docker-compose-examples/grist-with-postgres-redis-minio
2. Run docker-compose up -d

Describe the expected behavior

Workaround:

diff --git a/docker-compose-examples/grist-with-postgres-redis-minio/docker-compose.yml b/docker-compose-examples/grist-with-postgres-redis-minio/docker-compose.yml
index 1202fd27..ec86447a 100644
--- a/docker-compose-examples/grist-with-postgres-redis-minio/docker-compose.yml
+++ b/docker-compose-examples/grist-with-postgres-redis-minio/docker-compose.yml
@@ -35,6 +35,7 @@ services:
 
   grist-db:
     image: postgres:alpine
+    command: -c jit=off
     environment:
         POSTGRES_DB: grist
         POSTGRES_USER: grist

Where have you encountered this bug?

• On docs.getgrist.com
• On a self-hosted instance

Instance information (when self-hosting only)

• Grist instance:

  • Version:
  • URL (if it's OK for you to share it):
  • Installation mode: docker/kubernetes/...
  • Architecture: single-worker/multi-workers

• Browser name, version and platforms on which you could reproduce the bug:

• Link to browser console log if relevant:

• Link to server log if relevant:

[paulfitz]

I was wondering if we should maybe just SET jit = off or SET LOCAL jit = off from the app, rather than making everyone fiddle with their postgres settings forever. Side benefit: that way if eventually the issue is resolved either in Grist or in Postgres, the setting could be removed.

cc @Spoffy @jordigh