Re: Do we need so many hint bits? - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Do we need so many hint bits?
Date
Msg-id CA+U5nMJ5_7WqYjopVLQRwNto1QyESvVjv=PJ7P80YWuUFwpbWg@mail.gmail.com
Whole thread Raw
In response to Re: Do we need so many hint bits?  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: support for LDAP URLs
Next
From: Pavel Stehule
Date:
Subject: proposal: a width specification for s specifier (format function), fix behave when positional and ordered placeholders are used