Re: Why isn't my table auto-analyzed/vacuumed?
| От | Ron Johnson |
|---|---|
| Тема | Re: Why isn't my table auto-analyzed/vacuumed? |
| Дата | |
| Msg-id | CANzqJaD2uCty477Vgna4Q13Ltu-yAhtEOMuUU2hDuZYS+BaHHg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Why isn't my table auto-analyzed/vacuumed? (Dimitrios Apostolou <jimis@gmx.net>) |
| Список | pgsql-general |
On Thu, Oct 30, 2025 at 2:41 PM Dimitrios Apostolou <jimis@gmx.net> wrote:
On Thursday 2025-10-30 18:00, Ron Johnson wrote:
>On Thu, Oct 30, 2025 at 11:55 AM Dimitrios Apostolou <jimis@gmx.net> wrote:
> > SELECT name,setting FROM pg_settings WHERE name ILIKE '%factor%' ;
> name | setting
> ---------------------------------------+---------
> autovacuum_analyze_scale_factor | 0.1
>
>
>0.1 means 10%.
Thank you Ron! I was quite sure 0.1 meant 1/1000 because of this:
SELECT min_val,max_val FROM pg_settings WHERE name = 'autovacuum_analyze_scale_factor' \gx
-[ RECORD 1 ]
min_val | 0
max_val | 100
"Specifies a fraction of the table size to add to
autovacuum_analyze_threshold when deciding whether to trigger an ANALYZE. The default is 0.1 (10% of table size)."Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
В списке pgsql-general по дате отправления: