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

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Having problems with a 25 million row table on 8.1.3
Date: 2006-04-26 11:16:56
Message-ID: 1146050216.8202.126.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Kratz 2006-04-26 13:19:41 Ordering of records in group by not possible
Previous Message Florian G. Pflug 2006-04-26 10:21:17 Re: Automatically assuming a specific role after connecting