Skip site navigation (1) Skip section navigation (2)

Re: stored proc and inserting hundreds of thousands of rows

From: Joel Reymont <joelr1(at)gmail(dot)com>
To: Pierre C <lists(at)peufeu(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: stored proc and inserting hundreds of thousands of rows
Date: 2011-04-30 18:14:31
Message-ID: 7582830307139292886@unknownmsgid (view raw or flat)
Thread:
Lists: pgsql-performance
I'm calculating distance between probability vectors, e.g. topics that
a document belongs to and the topics of an ad.

The distance function is already a C function. Topics are float8[150].

Distance is calculated against all documents in the database so it's
arable scan.

Sent from my comfortable recliner

On 30/04/2011, at 19:04, Pierre C <lists(at)peufeu(dot)com> wrote:

>
> If you want to search by geographical coordinates, you could use a gist index which can optimize that sort of things (like retrieving all rows which fit in a box).

In response to

Responses

pgsql-performance by date

Next:From: Kevin GrittnerDate: 2011-04-30 18:24:12
Subject: Re: stored proc and inserting hundreds of thousands of rows
Previous:From: Pierre CDate: 2011-04-30 18:04:51
Subject: Re: stored proc and inserting hundreds of thousands of rows

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group