Jorge Torralba wrote: > We setup a FDW server for a large table that has an hstore data type as on eof the coums. > > When we run the query directly on the FDW server > > select * from recent_events where account_id = 1 AND (attributes -> 'account_incident_id')::integer = 2617116 limit 10; > > The response is 2ms . which is awesome. > > When we run it from the remote server where we have the server defined, the query never returns. > > Our server definition is as follows. > > (host 'fdwserver', dbname 'mydb', port '5432', fetch_size '1000', use_remote_estimate 'true', extensions 'hstore') After debugging into this, it seems that the hstore operator -> cannot be pushed down because of collation problems. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
