X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C0DC6D1D5E4 for ; Tue, 17 Feb 2004 11:01:13 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 03990-04 for ; Tue, 17 Feb 2004 07:01:10 -0400 (AST) Received: from frodo.hserus.net (frodo.hserus.net [204.74.68.40]) by svr1.postgresql.org (Postfix) with ESMTP id 52D6DD1B511 for ; Tue, 17 Feb 2004 07:01:08 -0400 (AST) Received: from concord.pspl.co.in ([202.54.11.72]:61672 helo=frodo.hserus.net) by frodo.hserus.net with asmtp (Cipher TLSv1:DHE-RSA-AES256-SHA:256) (Exim 4.30 #0) id 1At2yU-000J6M-9L by authid with plain for ; Tue, 17 Feb 2004 16:31:10 +0530 Message-ID: <4031F464.2040406@frodo.hserus.net> Date: Tue, 17 Feb 2004 16:30:52 +0530 From: Shridhar Daithankar User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.6b) Gecko/20031205 Thunderbird/0.4 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Slow response of PostgreSQL References: <200402171039.i1HAd9u25077@ns2.khi.wol.net.pk> In-Reply-To: <200402171039.i1HAd9u25077@ns2.khi.wol.net.pk> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/180 X-Sequence-Number: 5704 Saleem Burhani Baloch wrote: > I changed the conf as you wrote. But now the time is changed from 50 sec to 65 sec. :( > I have not more 256 MB ram now. > When I execute the query the > Postmaster takes about 1.8 MB > Postgres session takes 18 MB ram only. > & psql takes 1.3 MB. > > After the query finishes the > Postgres session reducess memeory and just uses 10 MB ram. Can you post explain analyze result for the query? Shridhar