Search Postgresql Archives

Re: Having problems with a 25 million row table on 8.1.3

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

To: Tony Caduto <tony_caduto@xxxxxxxxxxxxxxxxxxxx>
Subject: Re: Having problems with a 25 million row table on 8.1.3
From: Simon Riggs <simon@xxxxxxxxxxxxxxx>
Date: Wed, 26 Apr 2006 12:16:56 +0100
Cc: pgsql-general@xxxxxxxxxxxxxx
In-reply-to: <444E8238.10603@xxxxxxxxxxxxxxxxxxxx>
References: <444E8238.10603@xxxxxxxxxxxxxxxxxxxx>

On Tue, 2006-04-25 at 15:10 -0500, Tony Caduto wrote:

> I have a client who has a 25 million row table that is used to keep 

> work_mem = 10240                        # min 64, size in KB

Try putting work_mem a lot higher to improve the sort speed.

-- 
  Simon Riggs             
  EnterpriseDB   http://www.enterprisedb.com

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

References:
- Having problems with a 25 million row table on 8.1.3
  - From: Tony Caduto

Prev by Date: Re: Automatically assuming a specific role after connecting
Next by Date: PL/Ruby, INOUT parameters / SETOF record
Previous by thread: Re: Having problems with a 25 million row table on 8.1.3
Next by thread: Re: Having problems with a 25 million row table on 8.1.3
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux