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