[postgis-users] Extent on multiple tables

[Markus Schaber]

Hi, Strk,

strk at refractions.net wrote:
[extent() and memory usage]
>>My local test here with a 35 million row table seems to prove this, as
>>the postmaster has a constant memory usage of 17M during the whole
>>sequential table scan.
> 
> Happy to know, thank you ;)
> Did you try with the subselect as well ?

Yes, it seems the same. The two UNION ALL queries seem to be processed
sequential. As the ALL keyword is given, there's no duplicate
elimination, and thus there's no need to keep anything in memory.

Markus