Markus Schaber <schabi(at)logix-tt(dot)com> writes:
> Hmm, how does effective_cach_size correspond with it? Shouldn't a high
> effective_cache_size have a similar effect?
It seems reasonable to suppose that effective_cache_size ought to be
used as a number indicating how much "stuff" would hang around from
query to query. Right now it's not used that way...
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Jim C. Nasby||Date: 2006-04-18 22:34:11|
|Subject: Re: creating of temporary table takes very long|
|Previous:||From: Tom Lane||Date: 2006-04-18 22:22:26|
|Subject: Re: merge>hash>loop |