On Fri, Mar 14, 2014 at 10:06 AM, acanada <acanada@xxxxxxx> wrote:
Hello Jeff,The lock time is not a problem. The problem is that takes too much time. I will need to add more fields to this table in the near future and I'd like to know if the process can be accelerated by any parameter, workaround or whatever...Thank you for your answer.
OK. Can you provide an explain (analyze, buffers), and the other information described here: http://wiki.postgresql.org/wiki/Slow_Query_Questions
It may be faster to make a new table by selecting a join on the existing tables and then replace the master table with it.
Also, if you are going to be doing a lot of bulk updates like this, lowering the fillfactor to below 50% might be helpful.
Cheers,
Jeff
