2010/11/12 Dmitriy Igrishin <dmitigr@xxxxxxxxx>: > Hey Peter, > > Unfortunately, there is no indexes on arrays (only on expressions). there are indexes on arrays - you can use a GiST, Gin indexes. regards Pavel > With hstore we can easily create GiST index for effective access. > > 2010/11/12 Peter Bex <Peter.Bex@xxxxxxxxx> >> >> On Fri, Nov 12, 2010 at 10:17:50AM +0300, Dmitriy Igrishin wrote: >> > Hey Mark, >> > >> > Yeah, I can't imagine an entity in a real project even with more than >> > 100 >> > columns. Its rare case. >> > But if you entities (rows/tuples) of some class (table) can contains >> > variable >> > set of columns (properties) you can look at hstore contrib module. >> >> What can also work extremely well is storing the data in an array. >> If you need to access the array based on more meaningful keys you could >> store key/index pairs in another table. >> >> This approach only works well if you have multiple arrays with the same >> layout. ÂYou probably also need to build up your query dynamically if >> you need to access variable numbers of datapoints. >> >> Cheers, >> Peter >> -- >> http://sjamaan.ath.cx >> -- >> "The process of preparing programs for a digital computer >> Âis especially attractive, not only because it can be economically >> Âand scientifically rewarding, but also because it can be an aesthetic >> Âexperience much like composing poetry or music." >> Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â-- Donald Knuth >> >> -- >> Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general > > > > -- > // Dmitriy. > > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
