Jim Nasby <jnasby@xxxxxxxxx> 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 older thread 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
