Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Wed, 26 Apr 2006 12:16:56 +0100
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
- References:
- Having problems with a 25 million row table on 8.1.3
- From: Tony Caduto
- Having problems with a 25 million row table on 8.1.3
- 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
- Indexes: