Re: REINDEX filtering in the backend - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: REINDEX filtering in the backend
Date
Msg-id 20190828050951.GH1965@paquier.xyz
Whole thread Raw
In response to Re: REINDEX filtering in the backend  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
On Wed, Aug 28, 2019 at 02:02:08PM +0900, Michael Paquier wrote:
> +       index = index_open(indexOid, AccessShareLock);
> +       numAtts = index->rd_index->indnatts;
> +       index_close(index, AccessShareLock);
> Wouldn't it be better to close that after doing the scan?
>
> Nit: I am pretty sure that this should be indented.
>
> Could you add tests with REINDEX CONCURRENTLY?

Bonus: support for reindexdb should be added.  Let's not forget about
it.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: REINDEX filtering in the backend
Next
From: Fabien COELHO
Date:
Subject: Re: pgbench - implement strict TPC-B benchmark