Tolu Aina

I haven't seen the write to Redis being slow. Also what is the structure of your database? Do you have lots of nested tables. are your services on different networks?...

In case this is of interest, I have added partial async support in the master branch. You can enable this with the environment variable. PS: this feature is still experimental...

- The initial sync is always the most demanding and requires a lot resources proportional to the data size and number. - I don't think ngram has any effect here...

- Do you know how many rows were synced in that period? - Are you using any plugins? - A high cpu usage suggests pgsync is not idle and is...

- Yes that plugin looks straightforward. - You should see something like this in the terminal meaning its waiting for an event to process - Specifically pending should be near...

- I think we only want to do this only if Row level security is enabled. is that a correct assumption? - Also is does the search_path need to include...

- I guess we would only need to apply these changes to the trigger on bootstrap. - We would also need to include all Postgres schemas in the schema.json -...

- The transaction logs is cleared at intervals defined by the env var `REPLICATION_SLOT_CLEANUP_INTERVAL` - You can modify this for your needs - The default is 180.0 secs - This...

So the db events should be equivalent to the redis events. In your case, nothing is being propagated to redis it seems. Do you use auth for redis? is this...

- One thing that certainly isn't right tis the `ELASTICSEARCH_SCHEME` and `ELASTICSEARCH_PORT`. - for https port should be 443 - Although I'm not sure if this is the current problem....