Re: effective_cache_size

Manfred Koizar <mkoi-pg(at)aon(dot)at> writes:
> The estimator only uses effective_cache_size, it never looks at
> NBuffers. So shouldn't we add
> if (effective_cache_size < NBuffers)

Pretty useless considering that effective_cache_size can be SET on the
fly...

In general, my philosophy has been not to constrain settings of
optimizer cost parameters more than absolutely necessary. For example,
the system will let you set random_page_cost to values between 0 and 1,
even though values less than 1 are surely nonsensical. Once in a while
someone might want to do that just for testing purposes...

regards, tom lane