Re: Querying distinct values from a large table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Richard Huxton <dev@xxxxxxxxxxxx>, pgsql-performance@xxxxxxxxxxxxxx
Subject: Re: Querying distinct values from a large table
From: Igor Lobanov <ilobanov@xxxxxxxxxx>
Date: Tue, 30 Jan 2007 15:36:12 +0600
In-reply-to: <45BF0C13.3070003@xxxxxxxxxxxx>
References: <45BF02DE.7080605@xxxxxxxxxx> <45BF0C13.3070003@xxxxxxxxxxxx>
User-agent: Thunderbird 1.5.0.9 (Windows/20061207)

Forgot to mention that our work_mem setting is 20480 Kb.

You might want to tryincreasing 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

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
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux