I wrote:
> Shigeru Hanada wrote:
>>> - Since a rescan is done by rewinding the cursor, is it necessary
>>> to have any other remote isolation level than READ COMMITED?
>>> There is only one query issued per transaction.
>>
>> If multiple foreign tables on a foreign server is used in a local
query,
>> multiple queries are executed in a remote transaction. So IMO
isolation
>> levels are useful even if remote query is executed only once.
>
> Oh, I see. You are right.
I thought some more about this and changed my mind.
If your query involves foreign scans on two foreign tables on the same
foreign server, these should always see the same snapshot, because
that's how it works with two scans in one query on local tables.
So I think it should be REPEATABLE READ in all cases - SERIALIZABLE
is not necessary as long as all you do is read.
Yours,
Laurenz Albe