From: Christian Paul B. Cosinas <cpc@cybees.com>
To: 'Mark Kirkwood' <markir@paradise.net.nz>
To: pgsql-performance@postgresql.org
Subject: Re: Used Memory
Date: Tue, 25 Oct 2005 03:20:09 -0000
Message-ID: <007801c5d913$018d2340$1e21100a@ghwk02002147> (raw)
In-Reply-To: <435DA143.3050100@paradise.net.nz>
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 :)
-----Original Message-----
From: Mark Kirkwood [mailto:markir@paradise.net.nz]
Sent: Tuesday, October 25, 2005 3:07 AM
To: Christian Paul B. Cosinas
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Used Memory
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
I choose Polesoft Lockspam to fight spam, and you?
http://www.polesoft.com/refer.html
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: cpc@cybees.com, markir@paradise.net.nz
Subject: Re: Used Memory
In-Reply-To: <007801c5d913$018d2340$1e21100a@ghwk02002147>
* 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