Re: COPY TO and VACUUM

Roberto Grandi <roberto(dot)grandi(at)trovaprezzi(dot)it> 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