| From: | Fernando Hevia <fhevia(at)gmail(dot)com> |
|---|---|
| To: | Wells Oliver <wells(dot)oliver(at)gmail(dot)com> |
| Cc: | Ron <ronljohnsonjr(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Postgres 12 -> 13 any need to re-index? |
| Date: | 2021-02-09 20:12:16 |
| Message-ID: | CAGYT1XRyodtDjhYSQPCZfXA6gXMQKa9W0GPvwD-Z3juw0s588Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
El mar, 9 de feb. de 2021 a la(s) 15:50, Wells Oliver (
wells(dot)oliver(at)gmail(dot)com) escribió:
> OK, that seems to have made a huge difference. and ran very quickly, ~15
> mins on a ~1TB database. Is there a way to better understand what it did?
> There's no way it rebuilt indexes in that amount of time. Also, as I said,
> I never did that going from 9->10->11->12, so it's interesting to me that
> it was so critical this time around.
>
>
It didn't rebuild indexes. It scanned rows to update statistics thereby
improving the planner's strategy to execute queries.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | dbatoCloud Solution | 2021-02-10 10:26:36 | function digest(unknown, unknown) does not exist |
| Previous Message | Ron | 2021-02-09 19:19:11 | Re: Postgres 12 -> 13 any need to re-index? |