| From: | "Chris Spotts" <rfusca(at)gmail(dot)com> |
|---|---|
| To: | "'David Kerr'" <dmk(at)mr-paradox(dot)net>, "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "'Merlin Moncure'" <mmoncure(at)gmail(dot)com>, "'Scott Marlowe'" <scott(dot)marlowe(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: killing processes |
| Date: | 2009-07-21 18:01:43 |
| Message-ID: | 00f101ca0a2d$4fcc0fe0$ef642fa0$@com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> - type, and access into a varwidth array is O(n), so the sorting
> - step you've got here is O(n^2). It might help to use unnest()
> - instead of this handmade version of it ...)
>
> unnest() is 8.4 only, right?
>
> I'm actually probably just going to install R and use the median
> function from that. (I was hoping to avoid installing all of R)
>
[Spotts, Christopher]
We have large data numeric data sets that we do medians over and due to
performance reasons, we eventually found it useful to take a smaller random
sample and median that...it was close enough for us. Just a thought.
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2009-07-21 18:18:24 | Re: killing processes |
| Previous Message | David Kerr | 2009-07-21 17:47:04 | Re: killing processes |