On Thu, Sep 5, 2013 at 9:05 AM, Roberto Grandi <roberto.grandi@xxxxxxxxxxxxxx> 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 be freeing it eventually. > Secondarly, if we launch a Vacuum after each "upload" we collide with other upload taht are running in parallel. I wouldn't do a manual vacuum after *each* upload. Doing one after every Nth upload, where N is estimated to make up about 1/5 of the table, should be good. You are probably IO limited, so you probably don't gain much by running these uploads in parallel, I would try to avoid that. But in any case, there shouldn't be a collision between manual vacuum and a concurrent upload. There would be one between two manual vacuums but you could code around that by explicitly locking the table in the correct mode nowait or with a timeout, and skipping the vacuum if it can't get the lock. > > Is it possible, form your point of view, working with isolation levels or table partitioning to minimize table space growing? Partitioning by vendor might work well for that purpose. Cheers, Jeff -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
