Re: Do we need so many hint bits?

On 15 November 2012 23:12, Simon Riggs <simon@2ndquadrant.com> wrote:

> We need detailed stats that allow many people to make their own tests
> and to report on what they find.

To work out how to proceed we need

* wait event times on clog accesses at table-level
* numbers of blocks dirtied by hint bit settings at table-level

That way we can see which tables need to have hint bits set and which don't.

-- 
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services