Re: Automatic Index Creation for Column Types

In my use, mainly arrays and hstore cols, including arrays of hstores.
These are column types that I suspect benefit from indexes more than
most column types.

Charles

On 13-08-19 8:14 AM, Pavel Stehule wrote:
> Hello
>
>
> 2013/8/19 Charles Sheridan <cesheri(at)swbell(dot)net
> <mailto:cesheri(at)swbell(dot)net>>
>
> Hi,
>
> I don't see indication that the capability described below exists in
> Postgres (or any RDBMS), so this is likely a feature request --
>
> For column types that are frequently defined in tables, and which are
> typically indexed, it would be helpful to be able to specify in
> the type
> definition of the column that its addition/creation into a table
> should
> be automatically accompanied by the creation of an associated index.
>
> Auto-index generation for a specific column type would be overridable
> for specific tables, as you wouldn't always want to auto-create an
> index
> at the time of column addition to a table. In the case of CREATE
> TABLE,
> this would be less of a concern, and more of a concern for ALTER TABLE
> ADD COLUMN.
>
> Such a configuration would also specify the type of index.
>
> What do you think ?
>
>
> It is relatively dangerous, I think. What is typical type that can be
> indexed?
>
> Regards
>
> Pavel
>
>
> Thanks,
> Charles Sheridan
>
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org
> <mailto:pgsql-hackers(at)postgresql(dot)org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>
>