Re: Trying to compute the median - Mailing list pgsql-general

From Maciej Bliziński
Subject Re: Trying to compute the median
Date
Msg-id 20040511142255.GA25194@dobranet.polbox.pl
Whole thread Raw
In response to Re: Trying to compute the median  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Trying to compute the median
Next
From: Dias Bantekas
Date:
Subject: Re: Data Encryption in PostgreSQL, and a Tutorial.