Postgres Pro
Downloads
Home   >   mailing lists

Re: Querying distinct values from a large table - Mailing list pgsql-performance

From Igor Lobanov
Subject Re: Querying distinct values from a large table
Date
Msg-id 45BF118C.90205@swsoft.com
Whole thread Raw
In response to Re: Querying distinct values from a large table  (Richard Huxton <dev@archonet.com>)
List pgsql-performance
Tree view 
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.

pgsql-performance by date:

Previous
From: Igor Lobanov
Date:
Subject: Re: Querying distinct values from a large table
Next
From: Richard Huxton
Date:
Subject: Re: Querying distinct values from a large table