Hello all,
I've just read this thread as I googled for "*how to give to autovacuum
priority on a table*"
I'm looking this because I have large table with lot of inserts/updates,
and to improve the system I want to force the first free autovacuum worker
to work on that table, of course if condition
On 03/03/2018 10:21 PM, Jim Nasby wrote:
> On 3/3/18 2:53 PM, Tomas Vondra wrote:
>> That largely depends on what knobs would be exposed. I'm against adding
>> some low-level knobs that perhaps 1% of the users will know how to tune,
>> and the rest will set it incorrectly. Some high-level options
On 3/3/18 2:53 PM, Tomas Vondra wrote:
That largely depends on what knobs would be exposed. I'm against adding
some low-level knobs that perhaps 1% of the users will know how to tune,
and the rest will set it incorrectly. Some high-level options that would
specify the workload type might work, bu
On 03/03/2018 08:32 PM, Jim Nasby wrote:
> On 2/19/18 10:00 AM, Tomas Vondra wrote:
>> So I don't think this is a very promising approach, unfortunately.
>>
>> What I think might work is having a separate pool of autovac workers,
>> dedicated to these high-priority tables. That still would not guar
On 2/19/18 10:00 AM, Tomas Vondra wrote:
So I don't think this is a very promising approach, unfortunately.
What I think might work is having a separate pool of autovac workers,
dedicated to these high-priority tables. That still would not guarantee
the high-priority tables are vacuumed immediat
On 3/2/18 4:07 AM, Ildus Kurbangaliev wrote:
> On Thu, 1 Mar 2018 23:39:34 -0800
> Andres Freund wrote:
>
>> Hi,
>>
>> On 2018-02-19 17:00:34 +0100, Tomas Vondra wrote:
>>> I have a hard time understanding how adding yet another autovacuum
>>> table-level knob makes the DBA's life any easier. Esp
On Thu, 1 Mar 2018 23:39:34 -0800
Andres Freund wrote:
> Hi,
>
> On 2018-02-19 17:00:34 +0100, Tomas Vondra wrote:
> > I have a hard time understanding how adding yet another autovacuum
> > table-level knob makes the DBA's life any easier. Especially when
> > the behavior is so unreliable and do
Hi,
On 2018-02-19 17:00:34 +0100, Tomas Vondra wrote:
> I have a hard time understanding how adding yet another autovacuum
> table-level knob makes the DBA's life any easier. Especially when the
> behavior is so unreliable and does not really guarantee when the
> high-priority table will be cleane
On 02/19/2018 03:38 PM, Ildus Kurbangaliev wrote:
> On Fri, 16 Feb 2018 21:48:14 +0900
> Masahiko Sawada wrote:
>
>> On Fri, Feb 16, 2018 at 7:50 PM, Ildus Kurbangaliev
>> wrote:
>>> On Fri, 16 Feb 2018 17:42:34 +0900
>>> Masahiko Sawada wrote:
>>>
On Thu, Feb 15, 2018 at 10:16 PM, Gri
On Fri, 16 Feb 2018 21:48:14 +0900
Masahiko Sawada wrote:
> On Fri, Feb 16, 2018 at 7:50 PM, Ildus Kurbangaliev
> wrote:
> > On Fri, 16 Feb 2018 17:42:34 +0900
> > Masahiko Sawada wrote:
> >
> >> On Thu, Feb 15, 2018 at 10:16 PM, Grigory Smolkin
> >> wrote:
> >> > On 02/15/2018 09:28 AM, M
On Fri, Feb 16, 2018 at 7:50 PM, Ildus Kurbangaliev
wrote:
> On Fri, 16 Feb 2018 17:42:34 +0900
> Masahiko Sawada wrote:
>
>> On Thu, Feb 15, 2018 at 10:16 PM, Grigory Smolkin
>> wrote:
>> > On 02/15/2018 09:28 AM, Masahiko Sawada wrote:
>> >
>> >> Hi,
>> >>
>> >> On Thu, Feb 8, 2018 at 11:01 PM
On Fri, 16 Feb 2018 17:42:34 +0900
Masahiko Sawada wrote:
> On Thu, Feb 15, 2018 at 10:16 PM, Grigory Smolkin
> wrote:
> > On 02/15/2018 09:28 AM, Masahiko Sawada wrote:
> >
> >> Hi,
> >>
> >> On Thu, Feb 8, 2018 at 11:01 PM, Ildus Kurbangaliev
> >> wrote:
> >>>
> >>> Hi,
> >>>
> >>> Attach
On Thu, Feb 15, 2018 at 10:16 PM, Grigory Smolkin
wrote:
> On 02/15/2018 09:28 AM, Masahiko Sawada wrote:
>
>> Hi,
>>
>> On Thu, Feb 8, 2018 at 11:01 PM, Ildus Kurbangaliev
>> wrote:
>>>
>>> Hi,
>>>
>>> Attached patch adds 'autovacuum_table_priority' to the current list of
>>> automatic vacuuming
On 02/15/2018 09:28 AM, Masahiko Sawada wrote:
Hi,
On Thu, Feb 8, 2018 at 11:01 PM, Ildus Kurbangaliev
wrote:
Hi,
Attached patch adds 'autovacuum_table_priority' to the current list of
automatic vacuuming settings. It's used in sorting of vacuumed tables in
autovacuum worker before actual va
Hi,
On Thu, Feb 8, 2018 at 11:01 PM, Ildus Kurbangaliev
wrote:
> Hi,
>
> Attached patch adds 'autovacuum_table_priority' to the current list of
> automatic vacuuming settings. It's used in sorting of vacuumed tables in
> autovacuum worker before actual vacuum.
>
> The idea is to give possibility
15 matches
Mail list logo
