Re: huge price database question..

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: huge price database question..
Дата
Msg-id 4F694391.2030900@hogranch.com
обсуждение исходный текст
Ответ на Re: huge price database question..  (Jim Green <student.northwestern@gmail.com>)
Ответы Re: huge price database question..  (Jim Green <student.northwestern@gmail.com>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: Jim Green
Дата:
Сообщение: Re: huge price database question..
Следующее
От: Andy Colson
Дата:
Сообщение: Re: huge price database question..