Re: Adding new field to big table

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Adding new field to big table
Дата
Msg-id CAMkU=1z-D4GnJGh6PNSg-e9eJSQ6t43ME9R5k7QQuRKXf_1bwQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Adding new field to big table  ("acanada" <acanada@cnio.es>)
Ответы Re: Adding new field to big table  ("acanada" <acanada@cnio.es>)
Список pgsql-performance
Дерево обсуждения
On Fri, Mar 14, 2014 at 10:06 AM, acanada <acanada@cnio.es> 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: "acanada"
Дата:
Сообщение: Re: Adding new field to big table
Следующее
От: "acanada"
Дата:
Сообщение: Re: Adding new field to big table