Re: Indexes with ccnew, ccnew1, etc.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Indexes with ccnew, ccnew1, etc.
Date: 2021-03-11 18:50:20
Message-ID: 2311117.1615488620@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Wells Oliver <wells(dot)oliver(at)gmail(dot)com> writes:
> I've notice a few of these pop up: duplicate indexes with _ccnew, _ccnew1,
> etc appended. I'm not entirely sure how it's happened: I'm certainly not
> manually creating them.

The REINDEX man page explains that, I believe.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Wells Oliver 2021-03-11 18:51:48 Re: Indexes with ccnew, ccnew1, etc.
Previous Message Wells Oliver 2021-03-11 18:41:50 Indexes with ccnew, ccnew1, etc.