Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Querying distinct values from a large table
- From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
- To: Gregory Stark <gsstark(at)mit(dot)edu>
- Cc: Luke Lonergan <llonergan(at)greenplum(dot)com>, 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 14:04:43 -0300
Gregory Stark 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. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
- Follow-Ups:
- Re: Querying distinct values from a large table
- From: Tom Lane
- Re: Querying distinct values from a large table
- From: Luke Lonergan
- Re: Querying distinct values from a large table
- References:
- Re: Querying distinct values from a large table
- From: Luke Lonergan
- Re: Querying distinct values from a large table
- From: Gregory Stark
- 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: