Re: index structure for 114-dimension vector
От
Jeff Davis
Тема
Re: index structure for 114-dimension vector
Дата
Msg-id
1177105284.28383.31.camel@dogma.v10.wvs
Ответ на
index structure for 114-dimension vector (Andrew Lazarus)
Список
Дерево обсуждения
Basic Q on superfluous primary keys "Kynn Jones" <kynnjo@gmail.com>
Re: Basic Q on superfluous primary keys Bill Moran <wmoran@collaborativefusion.com>
Re: Basic Q on superfluous primary keys "Merlin Moncure" <mmoncure@gmail.com>
Re: Basic Q on superfluous primary keys "Craig A. James" <cjames@modgraph-usa.com>
Re: Basic Q on superfluous primary keys Ron Mayer <rm_pg@cheapcomplexdevices.com>
Re: Basic Q on superfluous primary keys "Merlin Moncure" <mmoncure@gmail.com>
Re: Basic Q on superfluous primary keys Greg Smith <gsmith@gregsmith.com>
Re: Basic Q on superfluous primary keys "Merlin Moncure" <mmoncure@gmail.com>
Re: Basic Q on superfluous primary keys "Dave Dutcher" <dave@tridecap.com>
Re: Basic Q on superfluous primary keys "Merlin Moncure" <mmoncure@gmail.com>
index structure for 114-dimension vector Andrew Lazarus <andrew@pillette.com>
Re: index structure for 114-dimension vector Jeff Davis <pgsql@j-davis.com>
Re: index structure for 114-dimension vector Mark Kirkwood <markir@paradise.net.nz>
Re: index structure for 114-dimension vector Andrew Lazarus <andrew@pillette.com>
Re: index structure for 114-dimension vector Tom Lane <tgl@sss.pgh.pa.us>
Re: index structure for 114-dimension vector Mark Kirkwood <markir@paradise.net.nz>
Re: index structure for 114-dimension vector Arjen van der Meijden <acmmailing@tweakers.net>
Re: index structure for 114-dimension vector C Storm <christian.storm@gmail.com>
Re: index structure for 114-dimension vector "Alexander Staubo" <alex@purefiction.net>
Re: index structure for 114-dimension vector Oleg Bartunov <oleg@sai.msu.su>
Re: index structure for 114-dimension vector Andrew Lazarus <andrew@pillette.com>
Re: index structure for 114-dimension vector "Alexander Staubo" <alex@purefiction.net>
Re: Basic Q on superfluous primary keys "Craig A. James" <cjames@emolecules.com>
Re: Basic Q on superfluous primary keys "Craig A. James" <cjames@modgraph-usa.com>
Re: Basic Q on superfluous primary keys Jeff Davis <pgsql@j-davis.com>
Re: Basic Q on superfluous primary keys Richard Huxton <dev@archonet.com>
Re: Basic Q on superfluous primary keys Greg Smith <gsmith@gregsmith.com>
Re: Basic Q on superfluous primary keys "Merlin Moncure" <mmoncure@gmail.com>
Re: Basic Q on superfluous primary keys "Craig A. James" <cjames@modgraph-usa.com>
On Fri, 2007-04-20 at 12:07 -0700, Andrew Lazarus wrote:
> I have a table with 2.5 million real[] arrays. (They are points in a
> time series.) Given a new array X, I'd like to find, say, the 25
> closest to X in some sense--for simplification, let's just say in the
> usual vector norm. Speed is critical here, and everything I have tried
> has been too slow.
>
> I imported the cube contrib package, and I tried creating an index on
> a cube of the last 6 elements, which are the most important. Then I
Have you tried just making normal indexes on each of the last 6 elements
and see if postgresql will use a BitmapAnd to combine them?
Regards,
Jeff Davis
В списке pgsql-performance по дате отправления
