From: Mark Kirkwood <markir@paradise.net.nz>
To: Christian Paul B. Cosinas <cpc@cybees.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Used Memory
Date: Tue, 25 Oct 2005 17:14:35 +1300
Message-ID: <435DB12B.5030901@paradise.net.nz> (raw)
In-Reply-To: <007801c5d913$018d2340$1e21100a@ghwk02002147>
References: <007801c5d913$018d2340$1e21100a@ghwk02002147>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: markir@paradise.net.nz, cpc@cybees.com
Subject: Re: Used Memory
In-Reply-To: <435DB12B.5030901@paradise.net.nz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox