On Mon, Jun 29, 2009 at 8:14 PM, Anderson Valadares<andervalbh@xxxxxxxxx> wrote: > Hi all > I have a software developed in Delphi as a Windows Service, but, i don't > know why, it consumns an unexpected large system memory (515m). > The service access PostgresSQL by ODBC driver (psqlodbc_08_03_0400) and it > consist simply of a loop calling a procedure PL/PGSQL. How to discover what > is causing or why this high memory usage ? What objects are being used on > this session ? you are definitely leaking. resident memory size (RES) of 1gb+ is not a normal situation. I bet that you have a transaction that is not being completed. First thing to check is: select * from pg_stat_activity; and see if your backend (by pid) is in IDLE, running a query, or 'IDLE in transaction.' Also, try not to top-post(paste your response _below_ mine), and send plain text email where possible. merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
