Re: stored proc and inserting hundreds of thousands of rows - Mailing list pgsql-performance

From Joel Reymont
Subject Re: stored proc and inserting hundreds of thousands of rows
Date
Msg-id 7582830307139292886@unknownmsgid
Whole thread Raw
In response to Re: stored proc and inserting hundreds of thousands of rows  ("Pierre C" <lists@peufeu.com>)
Responses Re: stored proc and inserting hundreds of thousands of rows  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List 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@peufeu.com> wrote:

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

pgsql-performance by date:

Previous
From: "Pierre C"
Date:
Subject: Re: stored proc and inserting hundreds of thousands of rows
Next
From: "Kevin Grittner"
Date:
Subject: Re: stored proc and inserting hundreds of thousands of rows