utsav wrote:
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.
are you vacuuming frequently enough? in postgresql, UPDATE behaves much like DELETE and INSERT, and the DELETE'd old tuples don't get freed until the tables are vacuumed.
I will note, this app likely would perform 4-10X faster on 8.3 or 8.4 due to significant improvements in how UPDATE functions (and overall performance improvements).
7.3 is a -really- old release now. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
