Data Directory size increasing abnormally

["utsav" <utsav.turray@xxxxxxxxxxxx>]

Dear All,

I am using postgres 7.3 version on RHEL 4.0.

 

I have a table pdbsynchtable with the following structure 

 

  caption varchar(1020) NOT NULL,
  uid varchar(255) NOT NULL,
  destination varchar(1020) NOT NULL,
  commanddata text NOT NULL,
  command varchar(50) NOT NULL,
  transactionid varchar(10) NOT NULL,
  statusflag char(2) DEFAULT '01',
  requestcounter int4 DEFAULT 0,
  requestdatetime timestamp DEFAULT now(),
  requesttype char(1) DEFAULT 'A',
  actiondatetime timestamp DEFAULT now(),
  "comment" text DEFAULT 'Entered into the System',
  source varchar(255),
  sourceip varchar(50),
  sourcebocode varchar(4),
  sourcedocode int4,
  destinationbocode varchar(4),
  destinationdocode int4,
  CONSTRAINT pk_key PRIMARY KEY (uid)
 

The commanddata field consists of binary data of a txt file whose size is between 1kb to 4kb and there is a high frequecy of updates on this table (approx twice in a sec)

 

A strange behaviour is observerd in the physical files with respect to this table. The size of the file is growing abnormally in GBs. Suppose the file name (oid of relation )with respect to the table is "18924" I could find entries of 1 GB files like 18924, 18924.1, 18924.2 , 18924.3......18924.40  in the data directory, though there are on 10k records in the table.    

I have attached the of list command of the data directory.

Kindly help me in finding , why this is happening because, the server is running out of space.

 
Thanks and Regards

Utsav Turray

 

 

Disclaimer :- This e-mail and any attachment may contain confidential, proprietary or legally privileged information. If you are not the origin al intended recipient and have erroneously received this message, you are prohibited from using, copying, altering or disclosing the content of this message. Please delete it immediately and notify the sender. Newgen Software Technologies Ltd (NSTL) accepts no responsibilities for los s or damage arising from the use of the information transmitted by this email including damages from virus and further acknowledges that no bin ding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of NSTL.

/dbdata1/data/base/16976/

-rw-------  1 postgres postgres 1073741824 Nov 16 12:38 18924.1
-rw-------  1 postgres postgres 1073741824 Nov 16 11:13 18924.10
-rw-------  1 postgres postgres 1073741824 Nov 16 11:13 18924.11
-rw-------  1 postgres postgres 1073741824 Nov 16 11:13 18924.12
-rw-------  1 postgres postgres 1073741824 Nov 16 11:13 18924.13
-rw-------  1 postgres postgres 1073741824 Nov 16 11:13 18924.14
-rw-------  1 postgres postgres 1073741824 Sep 24 19:12 18924.15
-rw-------  1 postgres postgres 1073741824 Nov 16 11:13 18924.16
-rw-------  1 postgres postgres 1073741824 Nov 16 11:13 18924.17
-rw-------  1 postgres postgres 1073741824 Sep 24 19:12 18924.18
-rw-------  1 postgres postgres 1073741824 Nov 16 11:13 18924.19
-rw-------  1 postgres postgres 1073741824 Jan 15  2009 18924.2
-rw-------  1 postgres postgres 1073741824 Nov 16 11:13 18924.20
-rw-------  1 postgres postgres 1073741824 Nov 16 11:13 18924.21
-rw-------  1 postgres postgres 1073741824 Nov 16 11:13 18924.22
-rw-------  1 postgres postgres 1073741824 Nov 16 11:13 18924.23
-rw-------  1 postgres postgres 1073741824 Sep 24 19:12 18924.24
-rw-------  1 postgres postgres 1073741824 Nov 16 11:13 18924.25
-rw-------  1 postgres postgres 1073741824 Sep 24 19:12 18924.26
-rw-------  1 postgres postgres 1073741824 Sep 24 19:12 18924.27
-rw-------  1 postgres postgres 1073741824 Sep 24 19:12 18924.28
-rw-------  1 postgres postgres 1073741824 Nov 16 11:13 18924.29
-rw-------  1 postgres postgres 1073741824 Feb 25  2009 18924.3
-rw-------  1 postgres postgres 1073741824 Nov 16 11:13 18924.30
-rw-------  1 postgres postgres 1073741824 Nov 16 11:13 18924.31
-rw-------  1 postgres postgres 1073741824 Nov 16 11:13 18924.32
-rw-------  1 postgres postgres 1073741824 Nov 16 11:13 18924.33
-rw-------  1 postgres postgres 1073741824 Nov 16 11:13 18924.34
-rw-------  1 postgres postgres 1073741824 Nov 16 11:13 18924.35
-rw-------  1 postgres postgres 1073741824 Nov 16 11:13 18924.36
-rw-------  1 postgres postgres 1073741824 Nov 16 11:16 18924.37
-rw-------  1 postgres postgres 1073741824 Nov 16 11:58 18924.38
-rw-------  1 postgres postgres 1073741824 Nov 16 12:01 18924.39
-rw-------  1 postgres postgres 1073741824 Feb 25  2009 18924.4
-rw-------  1 postgres postgres  829988864 Nov 16 14:16 18924.40
-rw-------  1 postgres postgres 1073741824 Feb 25  2009 18924.5
-rw-------  1 postgres postgres 1073741824 Mar  5  2009 18924.6
-rw-------  1 postgres postgres 1073741824 Mar  5  2009 18924.7
-rw-------  1 postgres postgres 1073741824 Mar 19  2009 18924.8
-rw-------  1 postgres postgres 1073741824 Nov 16 11:13 18924.9

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general