Re: [HACKERS] Automatic Index Creation for Column Types

Agree, these are significant concerns. Just to make sure the scope of the proposal is clear, I'm referring to col types created via CREATE TYPE, i.e. locally-defined col types of much tighter granularity than standard col types like INTEGER. Locally, one could adopt a naming convention for the

Re: [HACKERS] Automatic Index Creation for Column Types

On 08/19/2013 09:10 AM, Charles Sheridan wrote: 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

Re: [HACKERS] Automatic Index Creation for Column Types

2013/8/19 Charles Sheridan > 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 h

Re: [HACKERS] 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 > Hi, I d

Re: [HACKERS] Automatic Index Creation for Column Types

Hello 2013/8/19 Charles Sheridan > 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