Skip site navigation (1) Skip section navigation (2)

High consumns memory

From: Anderson Valadares <andervalbh(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: High consumns memory
Date: 2009-04-14 18:05:31
Message-ID: fa11ab140904141105h496a9cbasf2dcebcf5b5a46bd@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
I have a software developed in Delphi as a Windows Service, but, i don't
know why, it consumns an unexpected large system memory (1.3g).
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 ?
Software developed in Delphi 7 as a windows service.
PostgresSQL 8.3.6 Database with PostGis extension

Server p52a
S.O.: Red Hat Enterprise Linux AS release 4 (Nahant Update 1)
      linux 2.6.9-11.EL #1 SMP ppc64 ppc64 ppc64 GNU/Linux
S.O. information

Date 13/04/2009

top - 15:20:35 up 10 days, 14:22,  1 user,  load average: 0.80, 0.66, 0.63
Tasks: 134 total,   2 running, 132 sleeping,   0 stopped,   0 zombie
Cpu(s):  3.2% us,  0.1% sy,  0.0% ni, 96.2% id,  0.3% wa,  0.1% hi,  0.1% si
Mem:   4107392k total,  1552168k used,  2555224k free,    10172k buffers
Swap:  2031608k total,    79740k used,  1951868k free,  1402644k cached

  PID USER      PR  NI  VIRT SWAP  RES  SHR DATA CODE S %CPU %MEM    TIME+
COMMAND
 1843 postgres  16   0  857m 664m 193m 186m 7120 3540 R 19.9  4.8   0:06.13
postgres: citgis citgis 10.255.100.73(1557) SELECT


Date 14/04/2009

top - 12:51:44 up 11 days, 11:54,  1 user,  load average: 0.41, 0.45, 0.42
Tasks: 128 total,   1 running, 127 sleeping,   0 stopped,   0 zombie
Cpu(s):  3.8% us,  0.1% sy,  0.0% ni, 95.7% id,  0.2% wa,  0.1% hi,  0.0% si
Mem:   4107392k total,  4097504k used,     9888k free,    48252k buffers
Swap:  2031608k total,    62680k used,  1968928k free,  2804800k cached

  PID USER      PR  NI  VIRT SWAP  RES  SHR DATA CODE S %CPU %MEM    TIME+
COMMAND
 1843 postgres  15   0 1896m 114m 1.7g 737m 1.0g 3540 S 26.9 44.4 181:59.47
postgres: citgis citgis 10.255.100.73(1557) idle

As shown in column DATA(7120) on 03/04 and on 04/04 (1.0g) been a
significant increase in the consumption of memory.


postgresql.conf information:

               name               |                        setting       |
unit
 ---------------------------------+--------------------------------------+------
  archive_mode                    | on                                   |
  autovacuum_analyze_scale_factor | 0.4                                  |
  autovacuum_analyze_threshold    | 500                                  |
  autovacuum_vacuum_threshold     | 1000                                 |
  checkpoint_segments             | 15                                   |
  checkpoint_timeout              | 1800                                 | s
  default_statistics_target       | 50                                   |
  effective_cache_size            | 249600                               |
8kB
  fsync                           | on                                   |
  logging_collector               | on                                   |
  maintenance_work_mem            | 409600                               |
kB
  max_connections                 | 100                                  |
  max_fsm_pages                   | 3458000                              |
  shared_buffers                  | 64000                                |
8kB
  wal_buffers                     | 100                                  |
8kB
  work_mem                        | 5120                                 |
kB

pgsql-admin by date

Next:From: Benjamin MinshallDate: 2009-04-14 18:53:10
Subject: Backup only changed databases
Previous:From: Kevin GrittnerDate: 2009-04-14 17:19:23
Subject: Re: pg error log file monitor

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group