X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 999EA3103AD for ; Sat, 28 Jun 2003 11:38:53 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 77998-09 for ; Sat, 28 Jun 2003 08:38:42 -0300 (ADT) Received: from www.pspl.co.in (www.pspl.co.in [202.54.11.65]) by svr1.postgresql.org (Postfix) with ESMTP id 276BD3103AA for ; Sat, 28 Jun 2003 08:38:41 -0300 (ADT) Received: (from root@localhost) by www.pspl.co.in (8.11.6/8.11.6) id h5SBcfX15877 for ; Sat, 28 Jun 2003 17:08:41 +0530 Received: from daithan.intranet.pspl.co.in (daithan.intranet.pspl.co.in [192.168.7.161]) by www.pspl.co.in (8.11.6/8.11.0) with ESMTP id h5SBceG15872 for ; Sat, 28 Jun 2003 17:08:41 +0530 From: Shridhar Daithankar To: Subject: Re: 'best practises' to speed up sorting? tuning postgresql.conf Date: Sat, 28 Jun 2003 17:07:52 +0530 User-Agent: KMail/1.5.2 References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200306281707.52317.shridhar_daithankar@nospam.persistent.co.in> X-Archive-Number: 200306/203 X-Sequence-Number: 2287 On Saturday 28 June 2003 17:01, Chris Hutchinson wrote: > I'm wondering how to speed up sorting which is slowing a query run > regularly on a linux postgresql 7.3.3 system. > > The box is a dual PIII with 1Gb ram. The database is located on a 20Gb SCSI > disk, with WAL on a separate disk. > > The only changes I've made to postgresql.conf so far are: > shared_buffers=4000 > sort_mem=4000 sort_mem is in kbs. So you are setting it roughyl 4MB. Given that you don't seem to have any shortage of RAM, how about 32/64/128MB RAM till things work as expected? Of course, setting it so in postgresql.conf would be a bad idea. Just set for the session that makes this query and reset it back. Keep us posted on updates.. Shridhar