Re: [PERFORM] COPY TO and VACUUM

2013-09-16 Thread Roberto Grandi
;Roberto Grandi" Cc: pgsql-performance@postgresql.org, "Kevin Grittner" Inviato: Lunedì, 16 settembre 2013 2:18:44 Oggetto: Re: [PERFORM] COPY TO and VACUUM On Wed, Sep 11, 2013 at 11:14 PM, Roberto Grandi < roberto.gra...@trovaprezzi.it> wrote: > Hi Guys, > > we found

Re: [PERFORM] COPY TO and VACUUM

2013-09-15 Thread Jeff Janes
On Wed, Sep 11, 2013 at 11:14 PM, Roberto Grandi < roberto.gra...@trovaprezzi.it> wrote: > Hi Guys, > > we found a suitable solution for our process we run every 5-6 hours a > CLUSTER stement for our big table: this "lock" activities but allow us to > recover all available space. > If you can to

Re: [PERFORM] COPY TO and VACUUM

2013-09-11 Thread Roberto Grandi
es" A: "Roberto Grandi" Cc: "Kevin Grittner" , pgsql-performance@postgresql.org Inviato: Giovedì, 5 settembre 2013 20:14:26 Oggetto: Re: [PERFORM] COPY TO and VACUUM On Thu, Sep 5, 2013 at 9:05 AM, Roberto Grandi wrote: > Hi Jeff, > > the proble is that when con

Re: [PERFORM] COPY TO and VACUUM

2013-09-05 Thread Jeff Janes
On Thu, Sep 5, 2013 at 9:05 AM, Roberto Grandi wrote: > Hi Jeff, > > the proble is that when continously updloading vendors listing on our "big" > table the autovacuum is not able to free space as we would. It might not be able to free it (to be reused) as fast as you need it to, but it should b

Re: [PERFORM] COPY TO and VACUUM

2013-09-05 Thread David Kerr
ercoledì, 4 settembre 2013 18:29:13 - Oggetto: Re: [PERFORM] COPY TO and VACUUM - - On Tue, Sep 3, 2013 at 11:15 PM, Roberto Grandi - wrote: - > Hi kevin - > - > first of all thanks for your help. I did a mistake we are using postgres 8.3. - > - > I didn't expect COPY TO f

Re: [PERFORM] COPY TO and VACUUM

2013-09-05 Thread Roberto Grandi
ostgresql.org Inviato: Mercoledì, 4 settembre 2013 18:29:13 Oggetto: Re: [PERFORM] COPY TO and VACUUM On Tue, Sep 3, 2013 at 11:15 PM, Roberto Grandi wrote: > Hi kevin > > first of all thanks for your help. I did a mistake we are using postgres 8.3. > > I didn't expect COPY TO

Re: [PERFORM] COPY TO and VACUUM

2013-09-04 Thread Jeff Janes
On Tue, Sep 3, 2013 at 11:15 PM, Roberto Grandi wrote: > Hi kevin > > first of all thanks for your help. I did a mistake we are using postgres 8.3. > > I didn't expect COPY TO frees space but I was wondering Autovacumm delete > dead rows as soon as possible, in fact my scenario is: > > - Delete a

Re: [PERFORM] COPY TO and VACUUM

2013-09-04 Thread Kevin Grittner
Roberto Grandi wrote: > we are using postgres 8.3. > my scenario is: > > - Delete all products record for a vendor > - Reload all products record (from new listing) for the same >   vendor. > > Obviously we repeat this process continously and table space is > growing really fast. > > Can you sug

Re: [PERFORM] COPY TO and VACUUM

2013-09-03 Thread Roberto Grandi
ks in advance again. BR, Roberto - Messaggio originale - Da: "Kevin Grittner" A: "Roberto Grandi" , pgsql-performance@postgresql.org Inviato: Martedì, 3 settembre 2013 22:34:30 Oggetto: Re: [PERFORM] COPY TO and VACUUM Roberto Grandi wrote: > I'm running

Re: [PERFORM] COPY TO and VACUUM

2013-09-03 Thread Kevin Grittner
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