Data Directory size increasing abnormally

From: "utsav" <utsav(dot)turray(at)newgen(dot)co(dot)in>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Data Directory size increasing abnormally
Date: 2009-11-17 14:41:52
Message-ID: DB6D8F3B49B34E56B2EF1A94660C4598@central.newgen.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 original 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 loss or damage arising from the use of the information transmitted by this email including damages from virus and further acknowledges that no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of NSTL.

Attachment Content-Type Size
ll.txt text/plain 2.6 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-11-17 14:52:37 Re: WAL file question
Previous Message Tom Lane 2009-11-17 14:25:24 Re: postgresql-8.4.1 compile error (with Sun Studio 11)