Pavel Rotek wrote:
Hello, i have problem with following table... create table dataaction ( id INT4 not null, log text, primary key (id) ); It is the table for storing results of long running jobs. The log attribute takes approximately 5MB for one row (there is about 300 rows). My problem is, that table dataaction takes after restoring about 1,5G, but in few days grows to 79G(Toast space)...
1. What is happening with this table - just inserts, lots of updates? 2. What does SELECT sum(length(log)) FROM dataaction; show? > Vacuum on the table doesn't finish. A plain vacuum doesn't finish, or vacuum full doesn't finish? -- Richard Huxton Archonet Ltd -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
