Re: quick q re migration, index, stats - Mailing list pgsql-admin

From Scott Ribe
Subject Re: quick q re migration, index, stats
Date
Msg-id 3C49CA1B-004B-4B39-A8AF-3C376DA1ADEE@elevated-dev.com
Whole thread Raw
In response to Re: quick q re migration, index, stats  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-admin
> On Jan 6, 2021, at 6:56 PM, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
>
> By the way, you only need to rebuild those indexes that contain string data types,
> unless you want to make use of the new index compression feature in v13.

Thanks for pointing that it out; it hadn't occurred to me. But most of our indexes are strings, and we do have some
numerictypes that can have duplicates, so I think I'll be lazy and reindex all instead of trying to pick and choose. 





pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: quick q re migration, index, stats
Next
From: John Scalia
Date:
Subject: Showing materialized views