Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz> writes:
> I've recently seen examples of star-like queries using vast amounts of
> memory in one of our production systems. Here's a simplified example
> using synthetic data (see attached to generate if desired):
> SET geqo_threshold = 14;
> SET from_collapse_limit = 14;
> SET join_collapse_limit = 14;
Well, if you're going to do the above, you should be expecting the
planner to eat a lot of memory. There is a reason why the default
values of those parameters are significantly lower than that ...
regards, tom lane