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

Re: Strategy for doing number-crunching

From: Joe Conway <mail(at)joeconway(dot)com>
To: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
Cc: "ktm(at)rice(dot)edu" <ktm(at)rice(dot)edu>, Matthew Foster <matthew(dot)foster(at)noaa(dot)gov>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Strategy for doing number-crunching
Date: 2012-01-05 03:07:03
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
On 01/04/2012 09:04 AM, Sean Davis wrote:
> Good point.  I do not know what the performance is for these types of
> aggregates using Pl/R.  Perhaps Joe Conway or others could comment.

Depending on your approach should be similar to native R performance.
For example, you could use the spi interface to pull all the data at
once into a dataframe, and then process as Sean mentioned.


Joe Conway
credativ LLC:
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support

In response to

pgsql-novice by date

Next:From: Michael BeattieDate: 2012-01-05 03:43:27
Subject: Re: Verify My Database Isn't Slammed
Previous:From: Carlos MennensDate: 2012-01-04 21:30:07
Subject: Verify My Database Isn't Slammed

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