Roberto Grandi <roberto.grandi@xxxxxxxxxxxxxx> wrote: > I'm running Postgres 8.4 on Ubuntu 10.4 Linux server (64bit) > I have a big table tath contains product information: during the > day we perform a process that import new product continously with > statemtn COPY TO .. from files to this table. > > As result the table disk space is growing fast, it seems that > postgres is not able to free space for old rows. COPY TO would not free any space. Is there some other activity you haven't yet mentioned? > Is it possible to run a specific autovacuum acivity or say to > postgres "every time I delete a row, delete it immedialty and > don't take care of other transactions" ? You can configure autovacuum to be more aggressive, or you could run VACUUM statements. > Do you have any suggestion for me? 8.4 is getting pretty old; there have been a lot of autovacuum improvements in recent years. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
