Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning - Mailing list pgsql-performance

From Tom Lane
Subject Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning
Date
Msg-id 4332.1055274227@sss.pgh.pa.us
Whole thread Raw
In response to Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning  (Vincent van Leeuwen <pgsql.spam@vinz.nl>)
Responses Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning  (Vincent van Leeuwen <pgsql.spam@vinz.nl>)
List pgsql-performance
Vincent van Leeuwen <pgsql.spam@vinz.nl> writes:
> Halving the cpu_tuple_cost has given a very impressive performance boost
> (performance roughly doubled). I'm not sure why, because the plans of the
> large queries I was checking haven't changed as far as I can see, but maybe
> some smaller queries I didn't bother to check are using a different plan now.

That's very curious; I'd expect that parameter to have only marginal
effect in the first place (unless you make huge changes in it, of course).
It must have changed some plan that you didn't take note of.  If you can
find it I'd be interested to know.

> Just to be absolutely sure: all *_cost parameters only influence the
> chosen plan, right? There is absolutely nothing else influenced which
> doesn't show up in an EXPLAIN ANALYZE, right?

AFAIR, the only one of these parameters that the executor pays any
attention to is SORT_MEM; that will determine how soon the runtime code
starts to spill tuples to disk in sorts, hash tables, etc.

            regards, tom lane

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Hash or merge join instead of inner loop
Next
From: Joe Conway
Date:
Subject: Re: Re-ordering .CONF params ... questions for this list