Re: The query plan get all columns but I'm using only one column.

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Moises Lopez <moylop260(at)vauxoo(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: The query plan get all columns but I'm using only one column.
Date: 2020-04-29 19:36:35
Message-ID: CAHOFxGoo2SmxMGDLL4hRQsGCDVw_-u8L6mhSoqkKRXR5m5OQAg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

It is generally a very bad idea to turn off autovacuum. When it is causing
problems, it is likely that it needs to run more often to keep up with the
work, rather than not run at all. Certainly if it is turned off, it would
be critical to have a regularly scheduled process to vacuum analyze all
tables.

>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Lewis 2020-04-30 15:52:06 Re: The query plan get all columns but I'm using only one column.
Previous Message Moises Lopez 2020-04-29 19:21:37 Re: The query plan get all columns but I'm using only one column.