| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Beattie | 2012-01-05 03:43:27 | Re: Verify My Database Isn't Slammed |
| Previous Message | Carlos Mennens | 2012-01-04 21:30:07 | Verify My Database Isn't Slammed |