Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Querying distinct values from a large table
- 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: Tue, 30 Jan 2007 10:20:28 -0800
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
- Follow-Ups:
- Re: Querying distinct values from a large table
- From: Alvaro Herrera
- Re: Querying distinct values from a large table
- From: Josh Berkus
- Re: Querying distinct values from a large table
- From: Steinar H. Gunderson
- Re: Querying distinct values from a large table
- References:
- Re: Querying distinct values from a large table
- From: Alvaro Herrera
- Re: Querying distinct values from a large table
- Prev by Date: Re: Querying distinct values from a large table
- Next by Date: Re: Querying distinct values from a large table
- Previous by thread: Re: Querying distinct values from a large table
- Next by thread: Re: Querying distinct values from a large table
- Indexes: