Re: Performance killed with FDW when using CAST.

Laurenz Albe schrieb am 17.04.2019 um 07:03:
>> 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.

Do you happen to know if the JSONB operator -> (or ->>) can be pushed down?

Although I realize it would be a major change in the database design, maybe that would be a solution for Jorge.

Thomas