Tyler Conlon

Yes - I am almost certain that is happening. If I add any one_to_many relationship to the schema with this table I run out of disk space. There is not...

I was hoping to be able to debug this a little more as I getting this error on a single join. The two tables are large but not nearly as...

Yes - that would be great. This is the initial sync. I reduced the number of columns for this test and got an out of memory error this time. In...

@toluaina - any luck on extracting the query?

Sure - ``` QUERY PLAN ---------------------------------------------------------------------------------------------------------------------------------+ Hash Left Join (cost=6845232.35..8251322.35 rows=9472027 width=80) Hash Cond: (transactions_1.id = external_transactions_1.transaction_id) -> Seq Scan on transactions transactions_1 (cost=0.00..1135897.80 rows=9472027 width=20) Filter: (((xmin)::text)::bigint < 16748362)...

Wondering if there might be a work around for this large join.

Yes I am pretty sure it is. The result when running directly on the DB is the same. I will try to see if there is a configuration or instance...

I think this might be related to @voyc-jean s response here https://github.com/toluaina/pgsync/issues/191#issuecomment-941439617 If I kill all the sessions before running bootstrap it solves the issue.

I am having the same issue. After Initial sync all the data is in ES. Then when I add a record I see ```Polling db ebdb: 4 item(s)``` but when...

Ok - I will do some digging. We will probably have to find a work around.