Re: huge price database question..

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: huge price database question..
Date: 2012-03-21 02:57:21
Message-ID: 4F694391.2030900@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 03/20/12 7:49 PM, Jim Green wrote:
> yes its possible but I would more likely grab the data to R and get
> the avg in R..

avg() in the database is going to be a lot faster than copying the data
into memory for an application to process.

Also, you know there's a plR for postgres that lets you embed R
functions in the database server and invoke them in SQL statements??

--
john r pierce N 37, W 122
santa cruz ca mid-left coast

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy Colson 2012-03-21 03:01:01 Re: huge price database question..
Previous Message Jim Green 2012-03-21 02:49:08 Re: huge price database question..