From: Roberto Grandi <roberto.grandi@trovaprezzi.it>
To: pgsql-performance@postgresql.org
Subject: COPY TO and VACUUM
Date: Tue, 3 Sep 2013 18:16:13 +0200 (CEST)
Message-ID: <441706222.701556.1378224973704.JavaMail.root@trovaprezzi.it> (raw)
In-Reply-To: <535715181.700956.1378223895627.JavaMail.root@trovaprezzi.it>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Dear All
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.
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" ?
Do you have any suggestion for me?
I'll appreciate every suggeestion you can provide me.
Many thanks in advance
Roberto
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: roberto.grandi@trovaprezzi.it
Subject: Re: COPY TO and VACUUM
In-Reply-To: <441706222.701556.1378224973704.JavaMail.root@trovaprezzi.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox