Re: Automatic Index Creation for Column Types

2013/8/19 Charles Sheridan <cesheri(at)swbell(dot)net>

> 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.
>

depends on usage

when you use a arrays for time series, then you don't use a index usually

and in hstore, you should to decide between GiST or GIN index. What should
be default?

I don't think so this feature is a good idea. Maybe enhancing a domains
about possibility to specify a index type for domain.

Regards

Pavel

> Charles
>
>
>
> On 13-08-19 8:14 AM, Pavel Stehule wrote:
>
> Hello
>
>
> 2013/8/19 Charles Sheridan <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)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-hackers
>>
>
>
>