Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VGxJ8-00084F-GP for pgsql-performance@arkaria.postgresql.org; Tue, 03 Sep 2013 20:34:38 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VGxJ7-0002W5-TW for pgsql-performance@arkaria.postgresql.org; Tue, 03 Sep 2013 20:34:37 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VGxJ6-0002US-6O for pgsql-performance@postgresql.org; Tue, 03 Sep 2013 20:34:36 +0000 Received: from nm40-vm2.bullet.mail.bf1.yahoo.com ([72.30.239.210]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VGxJ1-00007Y-Ux for pgsql-performance@postgresql.org; Tue, 03 Sep 2013 20:34:35 +0000 Received: from [66.196.81.173] by nm40.bullet.mail.bf1.yahoo.com with NNFMP; 03 Sep 2013 20:34:31 -0000 Received: from [98.139.212.219] by tm19.bullet.mail.bf1.yahoo.com with NNFMP; 03 Sep 2013 20:34:31 -0000 Received: from [127.0.0.1] by omp1028.mail.bf1.yahoo.com with NNFMP; 03 Sep 2013 20:34:31 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 122472.39711.bm@omp1028.mail.bf1.yahoo.com Received: (qmail 97809 invoked by uid 60001); 3 Sep 2013 20:34:31 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ymail.com; s=s1024; t=1378240470; bh=oAI3nKwaEGG0qMm/eZuG9miMgieoBdUsRa92lkfrbuM=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=ySSVlRrL5FI6SovtQG+SgY2vQVCpss1PmJ+KlesSGepauAXcgVr87j53fB7mBQuP1zagNOUG4zxtC4JAtgU98hmBCN52e4EKiV056U4brkQQLDt8LJdszVTDATyV7XQLEFnAhzzIET92exI7vc4NiKr+N8Pn/EAaVZ1IzEKijdw= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=ymail.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=QQJaJQ+x2rgYlO3pH9icGLI9lmRiJ1ZKzecNlF3WZ5G1D5mK0MEoeMY9RqzzJkWling/HD+AdUUSCqUlsktunobJRrm5j83zL6EwwZrjlQ6SJ1pDu0Iz3higHkX96PrfX/Vvqk03LnuHDdTyQDja/IowgMBXxMqh2WlS4xXYUkY=; X-YMail-OSG: 3.hC0E8VM1lnsRYAdxh0tX3q15DNuZFbyzS9yXmGKxoKC7E wf6sf_kAYi7vPZ_ZnzpM1oUebkG5X1.xVyniPjSQzboDSJGGShfCFpbZszYo rcLlcvIdYmchdH5aWfnnGFjXRa9ZoQREb6gd6rydkkuCGZ.YON2CJxGTcMrc kyMeJkzAP1zXCI1iMxC1WUood2geUQ1YOkR9vnfp0F7n.Zr0_ZanLBjdGGcj l1PFEQg8D_1nx3.8EGIa4LWnH0Wrox8sASsXUprgYI8J_rw0iatwOmwZFgk5 iNIxC813iAbwz4H0gWTMa4.jb5CChr57KcFwB0JC1SGvC.zj9z1Uyjg3IgU. dKDjaAE8GwL6U.NXGpr.ElwxPgXON34WNRTKBsvHKOswV_bhWmnbSnI39jV3 XV7GGbkX63p11rpaJdcbYyralidWWXSh6WItYajqj8fIUVgZc6.DusNs36Ys 4wvP6duwzkF107vc2f3neqRBv0SwD8PgvYAfH1_cmw1MUwlABUflPpAC8dtK GgmS.dylZyWqv.S6EBHgLWhJg5rnkMBaTEHllhul.tH6pSmlGMeXXny6ZhVe HthPK1_sWA_fZJbFCLwKTYQUuB2PPk15o5Q-- Received: from [76.255.18.237] by web162905.mail.bf1.yahoo.com via HTTP; Tue, 03 Sep 2013 13:34:30 PDT X-Rocket-MIMEInfo: 002.001, Um9iZXJ0byBHcmFuZGkgPHJvYmVydG8uZ3JhbmRpQHRyb3ZhcHJlenppLml0PiB3cm90ZToKCj4gSSdtIHJ1bm5pbmcgUG9zdGdyZXMgOC40IG9uIFVidW50dSAxMC40IExpbnV4IHNlcnZlciAoNjRiaXQpCj4gSSBoYXZlIGEgYmlnIHRhYmxlIHRhdGggY29udGFpbnMgcHJvZHVjdCBpbmZvcm1hdGlvbjogZHVyaW5nIHRoZQo.IGRheSB3ZSBwZXJmb3JtIGEgcHJvY2VzcyB0aGF0IGltcG9ydCBuZXcgcHJvZHVjdCBjb250aW5vdXNseSB3aXRoCj4gc3RhdGVtdG4gQ09QWSBUTyAuLiBmcm9tIGZpbGVzIHRvIHQBMAEBAQE- X-Mailer: YahooMailWebService/0.8.156.576 References: <535715181.700956.1378223895627.JavaMail.root@trovaprezzi.it> <441706222.701556.1378224973704.JavaMail.root@trovaprezzi.it> Message-ID: <1378240470.79541.YahooMailNeo@web162905.mail.bf1.yahoo.com> Date: Tue, 3 Sep 2013 13:34:30 -0700 (PDT) From: Kevin Grittner Reply-To: Kevin Grittner Subject: Re: COPY TO and VACUUM To: Roberto Grandi , "pgsql-performance@postgresql.org" In-Reply-To: <441706222.701556.1378224973704.JavaMail.root@trovaprezzi.it> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: 0.7 (/) 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 Roberto Grandi 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.=A0 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 --=20 Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance