Horton
Menu

Re: Querying distinct values from a large table

Igor Lobanov <ilobanov@swsoft.com>

View thread
From: Igor Lobanov <ilobanov@swsoft.com>
To: Richard Huxton <dev@archonet.com>, pgsql-performance@postgresql.org
Date: 2007-01-30T09:36:12Z
Lists: pgsql-performance 
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.