On 9 August 2012 12:17, Amit Kapila <amit.kap...@huawei.com> wrote: > This optimization is to reduce the amount of WAL and definitely adding > anything extra will have some impact.
Of course. The question is "How much impact?". Each tweak has progressively less and less gain. This isn't a binary choice. Squeezing the last ounce of performance at the expense of all other concerns is not a sensible goal, IMHO, nor do we attempt that elsewhere. Given we're making no attempt to remove full page writes, which is clearly the biggest source of WAL volume currently, micro optimisation of other factors seems unwarranted at this stage. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
