On Fri, Feb 24, 2012 at 5:35 AM, Simon Riggs <si...@2ndquadrant.com> wrote: > On Thu, Feb 23, 2012 at 11:59 PM, Robert Haas <robertmh...@gmail.com> wrote: >> this doesn't feel like the right time to embark on a bunch of new >> engineering projects. > > IMHO this is exactly the right time to do full system tuning. Only > when we have major projects committed can we move towards measuring > things and correcting deficiencies.
Ideally we should measure things as we do them. Of course there will be cases that we fail to test which slip through the cracks, as Greg is now finding, and I agree we should try to fix any problems that we turn up during testing. But, as I said before, so far Greg hasn't turned up anything that can't be fixed by adjusting settings, so I don't see a compelling case for change on that basis. As a side point, there's no obvious reason why the problems Greg is identifying here couldn't have been identified before committing the background writer/checkpointer split. The fact that we didn't find them then suggests to me that we need to be more not less cautious in making further changes in this area. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers