X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id C6FABDAD10
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Tue, 25 Oct 2005 01:14:42 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 83128-02
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Tue, 25 Oct 2005 04:14:40 +0000 (GMT)
Received: from linda-5.paradise.net.nz (bm-5a.paradise.net.nz
 [203.96.152.184])
	by svr1.postgresql.org (Postfix) with ESMTP id 3CC05DA8B4
	for <pgsql-performance@postgresql.org>;
	Tue, 25 Oct 2005 01:14:39 -0300 (ADT)
Received: from smtp-3.paradise.net.nz
	(tclsnelb2-src-1.paradise.net.nz [203.96.152.177]) by
	linda-5.paradise.net.nz (Paradise.net.nz) with ESMTP id
	<0IOW00CRUEGE34@linda-5.paradise.net.nz> for
	pgsql-performance@postgresql.org; Tue, 25 Oct 2005 17:14:38 +1300 (NZDT)
Received: from [192.168.1.11] (218-101-13-43.paradise.net.nz [218.101.13.43])
	by smtp-3.paradise.net.nz (Postfix) with ESMTP id 122FFFA50AE; Tue,
	25 Oct 2005 17:14:38 +1300 (NZDT)
Date: Tue, 25 Oct 2005 17:14:35 +1300
From: Mark Kirkwood <markir@paradise.net.nz>
Subject: Re: Used Memory
In-reply-to: <007801c5d913$018d2340$1e21100a@ghwk02002147>
To: "Christian Paul B. Cosinas" <cpc@cybees.com>
Cc: pgsql-performance@postgresql.org
Message-id: <435DB12B.5030901@paradise.net.nz>
MIME-version: 1.0
Content-type: text/plain; format=flowed; charset=ISO-8859-1
Content-transfer-encoding: 7bit
X-Accept-Language: en-us, en
User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050726)
References: <007801c5d913$018d2340$1e21100a@ghwk02002147>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.144 required=5 tests=[AWL=0.144]
X-Spam-Level: 
X-Archive-Number: 200510/349
X-Sequence-Number: 15117

Christian Paul B. Cosinas wrote:
> Hi mark
> 
> I have so many functions, more than 100 functions in the database :) And I
> am dealing about 3 million of records in one database.
> And about 100 databases :)
> 

LOL - sorry, mis-understood your previous message to mean you had 
identified *one* query where 'fetch all' was causing the problem!

Having said that, to make much more progress, you probably want to 
identify those queries that are consuming your resource, pick one of two 
of the particularly bad ones and post 'em.

There are a number of ways to perform said identification, enabling 
stats collection might be worth a try.

regards

Mark