Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Querying distinct values from a large table
- From: Igor Lobanov <ilobanov(at)swsoft(dot)com>
- To: 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 15:36:12 +0600
Forgot to mention that our work_mem setting is 20480 Kb.
You might want to try increasing work_mem for this one query to speed any sorting.
-- Igor Lobanov Internal Development Engineer SWsoft, Inc.
- References:
- Querying distinct values from a large table
- From: Igor Lobanov
- Re: Querying distinct values from a large table
- From: Richard Huxton
- 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: