From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | cesheri(at)swbell(dot)net |
Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Automatic Index Creation for Column Types |
Date: | 2013-08-19 13:14:06 |
Message-ID: | CAFj8pRD=THQ+cOGX92ca5mQ+5vQTA=6DPRLYx0CrRC4ukk5gnA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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<http://www.postgresql.org/mailpref/pgsql-hackers>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Charles Sheridan | 2013-08-19 13:25:52 | Re: Automatic Index Creation for Column Types |
Previous Message | Charles Sheridan | 2013-08-19 13:10:25 | Automatic Index Creation for Column Types |