Re: Performance killed with FDW when using CAST.

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