| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(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" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Postgres 12 -> 13 any need to re-index? |
| Date: | 2021-02-09 18:54:59 |
| Message-ID: | CAKFQuwbxCD1cW8feNijtH3D_0xybwH+RaJoCWDu9dRKhgGnbmw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Tuesday, February 9, 2021, Wells Oliver <wells(dot)oliver(at)gmail(dot)com> wrote:
> 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?
>
>
Read the documentation?
>
> 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.
>
I’m more inclined to think you did the analyze and just don’t remember -
though its possible that the auto-vacuum daemon helped out behind the
scenes.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron | 2021-02-09 19:19:11 | Re: Postgres 12 -> 13 any need to re-index? |
| Previous Message | Wells Oliver | 2021-02-09 18:49:25 | Re: Postgres 12 -> 13 any need to re-index? |