Re: cache control? - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: cache control?
Date
Msg-id 000801c3e427$f2947960$5e00030a@LaptopDellXP
Whole thread Raw
In response to Re: cache control?  (Jan Wieck <JanWieck@Yahoo.com>)
List pgsql-hackers
Jan,

I think we should suspend further discussion for now...in summary:

ARC Buffer management is an important new performance feature for 7.5;
the implementation is a good one and should have positive benefit for
everybody's workload. ARC will adapt to a variety of situations and has
been designed to allow Vacuum to avoid interfering with user
applications.

That's the important bit: The implementation notes are detailed; I've
read them a few times to ensure I've got it straight. I am confident
that the situation I described CAN exist with regard to multiple
concurrent queries performing full table scans upon a single large
table. Further debate on that point is continuing because of my poor
explanation of that situation; forgive me. Thanks very much for your
further explanations and examples.

I will take a more practical tack on this now: providing evidence of a
real query mix that exhibits the described properties and quantifying
the effects and their frequency. If it IS worth it, and I accept that it
may not be, I'll have a hack at the very specialised improvement I was
suggesting, for very specific workload types.

Best Regards

Simon Riggs




pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Named arguments in function calls
Next
From: Tom Lane
Date:
Subject: Re: Named arguments in function calls