Re: Proposal : REINDEX SCHEMA - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Proposal : REINDEX SCHEMA
Date
Msg-id 20141012154446.GU7043@eldon.alvh.no-ip.org
Whole thread Raw
In response to Proposal : REINDEX SCHEMA  (Sawada Masahiko <sawada.mshk@gmail.com>)
Responses Re: Proposal : REINDEX SCHEMA
List pgsql-hackers
Sawada Masahiko wrote:
> Hi all,
> 
> Attached WIP patch adds new syntax REINEX SCHEMA which does reindexing
> all table of specified schema.
> There are syntax dose reindexing specified index, per table and per database,
> but we can not do reindexing per schema for now.

It seems doubtful that there really is much use for this feature, but if
there is, I think a better syntax precedent is the new ALTER TABLE ALL
IN TABLESPACE thingy, rather than your proposed REINDEX SCHEMA.
Something like REINDEX TABLE ALL IN SCHEMA perhaps.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: Ronan Dunklau
Date:
Subject: Re: Hide 'Execution time' in EXPLAIN (COSTS OFF)
Next
From: Tom Lane
Date:
Subject: Re: Hide 'Execution time' in EXPLAIN (COSTS OFF)