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 <cesh...@swbell.net
<mailto:cesh...@swbell.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@postgresql.org
<mailto:pgsql-hackers@postgresql.org>)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
