Re: merge>hash>loop - Mailing list pgsql-performance

From Tom Lane
Subject Re: merge>hash>loop
Date
Msg-id 19433.1145399208@sss.pgh.pa.us
Whole thread Raw
In response to Re: merge>hash>loop  (Markus Schaber <schabi@logix-tt.com>)
Responses Re: merge>hash>loop
List pgsql-performance
Markus Schaber <schabi@logix-tt.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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: merge>hash>loop
Next
From: "Jim C. Nasby"
Date:
Subject: Re: creating of temporary table takes very long