Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 8665D9FB652 for ; Tue, 1 May 2007 17:27:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 48873-03 for ; Tue, 1 May 2007 17:27:22 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.177]) by postgresql.org (Postfix) with ESMTP id BA1A69FA274 for ; Tue, 1 May 2007 17:27:24 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id a73so1688467pye for ; Tue, 01 May 2007 13:27:23 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth; b=T0EoKFzH0MC3YlmcpRsaE2a+fKpHjdsvOlo45x11SWETFR+oE1qXMy1kEf1BUMol3kH304PcIaf+qGVq7HIedIy2FWlBKQQNBQx3jY4CcdZgIH5bqs+9hDknCR22PP9CTBL7SNM81LP+zoP9cZV5pydyp9s1Xj3VGEW7zkka740= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth; b=U4IatZi+UjPobUiJG+At5U9NKVjDjiBoWMNo39QyAh7pXq9QQei8faGAL4nozxmV8HBhi5WBkxqw1XcBbvgLP6C+RcrORQodgYgRYOCsH8AFz983yYnJ/s+Xv2VksK9MXtzo5xddlYfJvUmStoLO31585MkCHXMF8TB5KQG9RP4= Received: by 10.65.81.10 with SMTP id i10mr14599049qbl.1178051243692; Tue, 01 May 2007 13:27:23 -0700 (PDT) Received: by 10.65.240.15 with HTTP; Tue, 1 May 2007 13:27:23 -0700 (PDT) Message-ID: <88daf38c0705011327u5d704932vcd7d9cfb4f29b62a@mail.gmail.com> Date: Tue, 1 May 2007 22:27:23 +0200 From: "Alexander Staubo" To: "Andrew Lazarus" Subject: Re: index structure for 114-dimension vector Cc: pgsql-performance@postgresql.org In-Reply-To: <408030727.20070501110924@pillette.com> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <01db01c781e4$c700bf30$2e00a8c0@tridecap.com> <1217328326.20070420120729@pillette.com> <88daf38c0704261534n2a6d3ab8g57482bae8672da53@mail.gmail.com> <408030727.20070501110924@pillette.com> X-Google-Sender-Auth: 1dc1f402b29c569e X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/4 X-Sequence-Number: 24394 On 5/1/07, Andrew Lazarus wrote: > Let me just thank the list, especially for the references. (I found > similar papers myself with Google: and to think I have a university > library alumni card and barely need it any more!) > > I'll write again on the sorts of results I get. Looking forward to hearing about them. I have worked with such dataset problems, but never attempted to apply them to a relational database such as PostgreSQL. If you want speed, nothing beats in-memory vectors on a modern CPU architecture. Alexander.