> 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..
utsav wrote:
Dear All,
I am using postgres 7.3 version on RHEL 4.0.
You should upgrade to a newer/the latest stable release
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
Note that with pgsql, the older the version you're running, the
greater your pgsql-fu must be to keep it happy.
With autovacuum and more efficient vacuuming all around in later
versions, your simple first step is to upgrade to 8.4.1 or 8.3.8 as
soon as possible. Until then, dump / reload that tab
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 gr
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 va
