Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VGtLh-00080T-Et for pgsql-performance@arkaria.postgresql.org; Tue, 03 Sep 2013 16:21:01 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VGtLg-0004Pz-Rc for pgsql-performance@arkaria.postgresql.org; Tue, 03 Sep 2013 16:21:00 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VGtLf-0004Ps-QH for pgsql-performance@postgresql.org; Tue, 03 Sep 2013 16:20:59 +0000 Received: from mail.trovaprezzi.it ([2.228.21.217]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VGtLZ-0004x9-PP for pgsql-performance@postgresql.org; Tue, 03 Sep 2013 16:20:59 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.trovaprezzi.it (Postfix) with ESMTP id 5688082009 for ; Tue, 3 Sep 2013 18:16:14 +0200 (CEST) X-Virus-Scanned: amavisd-new at zimbra.7pixel.local Received: from mail.trovaprezzi.it ([127.0.0.1]) by localhost (zimbra.7pixel.local [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 0kc31GhWZ5jK for ; Tue, 3 Sep 2013 18:16:14 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by mail.trovaprezzi.it (Postfix) with ESMTP id 1431B8200B for ; Tue, 3 Sep 2013 18:16:14 +0200 (CEST) X-Virus-Scanned: amavisd-new at zimbra.7pixel.local Received: from mail.trovaprezzi.it ([127.0.0.1]) by localhost (zimbra.7pixel.local [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id QERLddkK6JLd for ; Tue, 3 Sep 2013 18:16:13 +0200 (CEST) Received: from zimbra.7pixel.local (zimbra.7pixel.local [192.168.0.127]) by mail.trovaprezzi.it (Postfix) with ESMTP id C354882009 for ; Tue, 3 Sep 2013 18:16:13 +0200 (CEST) Date: Tue, 3 Sep 2013 18:16:13 +0200 (CEST) From: Roberto Grandi To: pgsql-performance@postgresql.org Message-ID: <441706222.701556.1378224973704.JavaMail.root@trovaprezzi.it> In-Reply-To: <535715181.700956.1378223895627.JavaMail.root@trovaprezzi.it> Subject: COPY TO and VACUUM MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Originating-IP: [91.204.80.113] X-Mailer: Zimbra 8.0.2_GA_5569 (ZimbraWebClient - FF22 (Win)/8.0.2_GA_5569) Thread-Topic: COPY TO and VACUUM Thread-Index: wAjkYwGwyTLGrJwK0q194iUnEfhhOA== X-Pg-Spam-Score: -2.9 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org 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