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 E694E30F616 for ; Tue, 1 Jul 2003 08:18:14 +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 05080-03 for ; Tue, 1 Jul 2003 05:18:04 -0300 (ADT) Received: from www.pspl.co.in (www.pspl.co.in [202.54.11.65]) by svr1.postgresql.org (Postfix) with ESMTP id DB76F310B6E for ; Tue, 1 Jul 2003 05:18:02 -0300 (ADT) Received: (from root@localhost) by www.pspl.co.in (8.11.6/8.11.6) id h618I2l15233 for ; Tue, 1 Jul 2003 13:48:02 +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 h618I1g15222 for ; Tue, 1 Jul 2003 13:48:02 +0530 From: Shridhar Daithankar To: pgsql-performance@postgresql.org Subject: Re: slower with the time Date: Tue, 1 Jul 2003 13:47:06 +0530 User-Agent: KMail/1.5.2 References: <3F013C85.2060202@pe-muc.de> <200307011318.00824.shridhar_daithankar@nospam.persistent.co.in> <3F0141E0.50703@pe-muc.de> In-Reply-To: <3F0141E0.50703@pe-muc.de> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200307011347.06532.shridhar_daithankar@nospam.persistent.co.in> X-Archive-Number: 200307/5 X-Sequence-Number: 2298 On Tuesday 01 July 2003 13:40, Juraj Porada wrote: > shared_buffers = 32 That is 32*8=256KB of memory. I thought default was 64. How much physical memory you have? I suggest you set it up something like 256 to start with. That may be too small as well but you haven't provided enough details to come up with a better one. > > I don't have much experience in tuning the database, but I think there > is a problem with a fragmentation of memory or so. > I don't known backgrounds. Read postgresql.conf and admin guide about runtime parameters. You need to tune shared buffers and effective_cache_size at least. Search performance archives about tuning these two. There is lot of material to cover in a single mail. HTH Shridhar