Re: Slow query on a one-tuple table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Luís Roberto Weck <luisroberto(at)siscobra(dot)com(dot)br>
Cc: Michael Lewis <mlewis(at)entrata(dot)com>, pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Slow query on a one-tuple table
Date: 2019-09-19 22:57:11
Message-ID: 18657.1568933831@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

=?UTF-8?Q?Lu=c3=ads_Roberto_Weck?= <luisroberto(at)siscobra(dot)com(dot)br> writes:
> As fas as autovacuum options, this is what I'm using:

> autovacuum_vacuum_scale_factor=0,

Ugh ... maybe I'm misremembering, but I *think* that has the effect
of disabling autovac completely. You don't want zero.

Check in pg_stat_all_tables.last_autovacuum to see if anything
is happening. If the dates seem reasonably current, then I'm wrong.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message MichaelDBA 2019-09-20 13:09:35 Re: Slow query on a one-tuple table
Previous Message Luís Roberto Weck 2019-09-19 22:46:46 Re: Slow query on a one-tuple table