Re: Trying to compute the median

Поиск
Список
Период
Сортировка
От Maciej Bliziński
Тема Re: Trying to compute the median
Дата
Msg-id 20040511142255.GA25194@dobranet.polbox.pl
обсуждение исходный текст
Ответ на Re: Trying to compute the median  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Tom Lane napisał:
> Yeah, that's a bug.  The patch is attached if you need it.  However, I
> think you will wind up looking for some other way to solve the problem,
> because this query won't scale well to large datasets.

I already did some googling and found two examples of median calculating
functions, but they didn't convince me; one of them was creating
temporary table to calculate the median, and it doesn't look for me like
a well-scaling solution.

What would you suggest then?

Maciej Bliziński

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Trying to compute the median
Следующее
От: Dias Bantekas
Дата:
Сообщение: Re: Data Encryption in PostgreSQL, and a Tutorial.