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: 4F0513D7.3030307@joeconway.com (view raw or flat)
Thread:
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

-- 
Joe Conway
credativ LLC: http://www.credativ.us
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-2014 The PostgreSQL Global Development Group