Re: Re: The fastest way to update thousands of rows in moderately sized table

Поиск

Список

Период

Сортировка

От	林士博
Тема	Re: Re: The fastest way to update thousands of rows in moderately sized table
Дата	24 июля 2015 г. 11:29:54
Msg-id	CACudzGh5y_ikE3imvUFE2gd+RCNU9LO6LyjakRzmWsQ7hvKj3g@mail.gmail.com обсуждение исходный текст
Ответ на	Re: The fastest way to update thousands of rows in moderately sized table (twoflower <standa.kurik@gmail.com>)
Ответы	Re: The fastest way to update thousands of rows in moderately sized table (twoflower <standa.kurik@gmail.com>) Re: Re: The fastest way to update thousands of rows in moderately sized table (林士博 <lin@repica.co.jp>)
Список	pgsql-general

Дерево обсуждения

Yes, partitioning by fk_job can significantly improve performance of this update.

And all the SELECTs with definited fk_job can be faster.

All you should check carefully is those SELECTs without definited fk_job.

2015-07-24 17:18 GMT+09:00 twoflower <standa.kurik@gmail.com>:

Thank you, I will look into those suggestions.

Meanwhile, I started experimenting with partitioning the table into smaller
tables, each holding rows with ID spanning 1 million values and using this
approach, the UPDATE takes 300ms. I have to check if all the SELECTs I am
issuing against the original table keep their performance, but so far it
seems they do, if the appropriate indexes are present on the child tables. I
was worried about the overhead of each query having to go through all
(currently) 58 partition tables, but it seems like it's not that big of a
deal.

--
View this message in context: http://postgresql.nabble.com/The-fastest-way-to-update-thousands-of-rows-in-moderately-sized-table-tp5859144p5859203.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general