Postgres Pro
Downloads
Home   >   mailing lists

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+U5nMK92PLjP-6fRArv0VDw7zikrZ7kMoQvdjiCEkSVhxhPAw@mail.gmail.com
Whole thread Raw
In response to Do we need so many hint bits?  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: Do we need so many hint bits?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
On 15 November 2012 19:42, Jeff Davis <pgsql@j-davis.com> wrote:

> many of the hint bits aren't terribly important

The truth is that nobody knows because there is no way of knowing.

A good way forwards would be to collect detailed stats by table. We
can then run various loads and see if any of this is worthwhile.

I'm sure we'd learn enough to understand how to optimise things.

track_hints?
track_buffers?

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

pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Doc patch making firm recommendation for setting the value of commit_delay
Next
From: Craig Ringer
Date:
Subject: Re: feature proposal - triggers by semantics