Alternatively, when I am trying to create an index on a column of a table which is of size 400 GB, it is taking roughly 7 hrs. The index is created only on one column which is not a primary key. The query I am using is, create index on table (colname). I request your valuable suggestions for the same. The configuration parameters are:
On Wed, Jul 4, 2018 at 10:27 PM, Peter Geoghegan <pg@bowt.ie> wrote:
On Tue, Jul 3, 2018 at 4:34 PM, Srinivas Karthik V <skarthikv.iitb@gmail.com> wrote: > @Peter: I was indexing the primary key of all the tables in tpc-ds. Some of > the fact tables has multiple columns as part of the primary key. Also, most > of them are numeric type.
Perhaps this is related in some way, since in both cases we're talking about a composite index on varlena-type columns, where the types have expensive comparisons. -- Peter Geoghegan