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
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 to the users to prioritize their tables
in autovacuum process.
--
---
Regar
16 matches
Mail list logo