2009/7/1 Merlin Moncure <mmoncure@xxxxxxxxx>: > 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 > Well, Thank for your answer. I double check what you ask me ... About the leaking memory, i think as you that i’m having it ... but i can find where is it or in which part of the procedure is responsable. The pg_start_activity does not return any uncompleted transation. I work with subtransations inside the main transaction. Any ideia ? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
