| From: | "Luke Lonergan" <llonergan(at)greenplum(dot)com> |
|---|---|
| To: | "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, "Gregory Stark" <gsstark(at)mit(dot)edu> |
| Cc: | "Chad Wagner" <chad(dot)wagner(at)gmail(dot)com>, "Simon Riggs" <simon(at)2ndquadrant(dot)com>, "Igor Lobanov" <ilobanov(at)swsoft(dot)com>, "Richard Huxton" <dev(at)archonet(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Querying distinct values from a large table |
| Date: | 2007-01-30 18:20:28 |
| Message-ID: | C1E4CC6C.19A2C%llonergan@greenplum.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Alvaro,
On 1/30/07 9:04 AM, "Alvaro Herrera" <alvherre(at)commandprompt(dot)com> wrote:
>> (Incidentally I'm not sure where 2-5x comes from. It's entirely dependant on
>> your data distribution. It's not hard to come up with distributions where
>> it's
>> 1000x as fast and others where there's no speed difference.)
>
> So the figure is really "1-1000x"? I bet this one is more impressive in
> PHB terms.
You got me - I'll bite - what's PHB?
- Luke
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steinar H. Gunderson | 2007-01-30 21:01:04 | Re: Querying distinct values from a large table |
| Previous Message | Alvaro Herrera | 2007-01-30 17:04:43 | Re: Querying distinct values from a large table |