Jim Nasby <jnasby@enova.com> writes:
> Oh, and in my 28 table case ru_minflt was 428 4k memory pages (1.7MB). Not a great measurement, but better than
nothing.I didn't detect anything noticeable on vmstat either, so I don't think the consumption is huge (an email in the
olderthread mentioned 1GB... I'm not seeing that).
Note that what matters here is not so much the number of base relations as
the number of possible join paths, which varies quite a lot depending on
the given and deduced join conditions. Worst-case is where join
conditions are available between any two base relations, which is not
a real common case.
regards, tom lane
