| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Sonam Sharma <sonams1209(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Analyze and vaccum |
| Date: | 2019-10-16 14:45:39 |
| Message-ID: | 0f987840-7c86-7143-320d-a927b323044b@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 10/16/19 5:32 AM, Sonam Sharma wrote:
> How auto vaccum and vaccum are different ?
> How analyze and auto analyze are different ?
>
> We were running load on a table which yesterday took 3 mins and today it
> took 30 mins. The autovaccum and autoanalyze are happening daily . But
> the manual vaccum and analyze ran on 26th.
> Can someone please help how these are different and if it help if I run
> a vaccum and analyze on table .
The docs will tell you:
https://www.postgresql.org/docs/11/routine-vacuuming.html
https://www.postgresql.org/docs/11/sql-analyze.html
https://www.postgresql.org/docs/11/sql-vacuum.html
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alan Hodgson | 2019-10-16 15:50:59 | Re: Text search lexer's handling of hyphens and negatives |
| Previous Message | Sonam Sharma | 2019-10-16 12:32:33 | Analyze and vaccum |