Re: Make ringbuffer threshold and ringbuffer sizes configurable?

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Make ringbuffer threshold and ringbuffer sizes configurable?
Date: 2020-02-06 18:15:04
Message-ID: CA+TgmoYA3dqs5e1GnTLrHNGYe7dWsNyyi7f-sWjuVfYh=Fh-yQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Feb 5, 2020 at 11:00 PM Andres Freund <andres(at)anarazel(dot)de> wrote:
> I.e. to maintain the current defaults, seqscan_ringbuffer_threshold
> would be -4.0, but could be also be set to an absolute 4GB (converted to
> pages). Probably would want a GUC show function that displays
> proportional values in a nice way.

I think this is kind of awkward given that our GUC system attributes
units to everything. It'd sort of be nicer to have two separate GUCs,
one measured as a multiple and the other measured in bytes, but maybe
that's just exchanging one form of confusion for another.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2020-02-06 18:31:07 Re: In PG12, query with float calculations is slower than PG11
Previous Message Andres Freund 2020-02-06 17:54:37 Re: Make ringbuffer threshold and ringbuffer sizes configurable?