Re: quick q re migration, index, stats

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: quick q re migration, index, stats
Date: 2021-01-07 03:24:46
Message-ID: 3C49CA1B-004B-4B39-A8AF-3C376DA1ADEE@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On Jan 6, 2021, at 6:56 PM, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)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 numeric types that can have duplicates, so I think I'll be lazy and reindex all instead of trying to pick and choose.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message John Scalia 2021-01-07 13:41:56 Showing materialized views
Previous Message Laurenz Albe 2021-01-07 01:56:11 Re: quick q re migration, index, stats