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 16:06:43 +1300
Message-ID: <435DA143.3050100@paradise.net.nz> (raw)
In-Reply-To: <004e01c5d90d$5ffdadb0$1e21100a@ghwk02002147>
References: <004e01c5d90d$5ffdadb0$1e21100a@ghwk02002147>
Christian Paul B. Cosinas wrote:
> Hi To all those who replied. Thank You.
>
> I monitor my database server a while ago and found out that memory is used
> extensively when I am fetching records from the database. I use the command
> "fetch all" in my VB Code and put it in a recordset.Also in this command the
> CPU utilization is used extensively.
>
> Is there something wrong with my code or is it just the way postgresql is
> behaving which I cannot do something about it?
>
> I just monitor one workstation connecting to the database server and it is
> already eating up about 20 % of the CPU of database server.
>
> Which I think will not be applicable to our system since we have a target of
> 25 PC connecting to the database server most of the time.
>
Could you post the query and the output of EXPLAIN ANALYZE?
In addition, have you run ANALYZE on all the tables in that database ?
(sorry, have to ask :-) ....).
cheers
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: <435DA143.3050100@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