Hi, Can you check by vacuum analyze the database. And run the query.**Remember don't use Vacuum full.On Tue, 24 Sep 2019, 12:07 am Luís Roberto Weck, <luisroberto@siscobra.com.br> wrote: Hi! Recently I've been looking for bloat in my databases and found a query to show which tables are more bloated and by how much. This is the explain plan on v12.3: https://explain.depesz.com/s/8dW8C And this is with v11: https://explain.depesz.com/s/diXY Both databases have approx. the same size and have the same schema, but on v12 I the query takes much longer to run.
Hi! Recently I've been looking for bloat in my databases and found a query to show which tables are more bloated and by how much. This is the explain plan on v12.3: https://explain.depesz.com/s/8dW8C And this is with v11: https://explain.depesz.com/s/diXY Both databases have approx. the same size and have the same schema, but on v12 I the query takes much longer to run.
pgsql-performance by date:
Соглашаюсь с условиями обработки персональных данных
