| From: | Maciej Bliziński <maciej(dot)blizinski(at)dobranet(dot)polbox(dot)pl> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Maciej Bliziński <maciej(dot)blizinski(at)dobranet(dot)polbox(dot)pl>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Trying to compute the median |
| Date: | 2004-05-11 14:22:55 |
| Message-ID: | 20040511142255.GA25194@dobranet.polbox.pl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dias Bantekas | 2004-05-11 14:57:43 | Re: Data Encryption in PostgreSQL, and a Tutorial. |
| Previous Message | Bruce Momjian | 2004-05-11 13:44:26 | Re: Adding MERGE to the TODO list (resend with subject) |