Re: max_expr_depth

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: max_expr_depth
Дата
Msg-id m3r8whb4o7.fsf@belphigor.mcnaught.org
обсуждение исходный текст
Ответ на max_expr_depth  (Joseph Shraibman <jks@selectacast.net>)
Список pgsql-general
Joseph Shraibman <jks@selectacast.net> writes:

> Compared to 1000 updates that took between 25 and 47 seconds, an update
> with 1000 itmes in the IN() took less than three seconds.

Did you wrap the 1000 separate updates in a transaction?

-Doug
--
The rain man gave me two cures; he said jump right in,
The first was Texas medicine--the second was just railroad gin,
And like a fool I mixed them, and it strangled up my mind,
Now people just get uglier, and I got no sense of time...          --Dylan

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

Предыдущее
От: "Dave Cramer"
Дата:
Сообщение: Re: Error: RelationBuildTriggers: 2 record(s) not found for rel customerinfo
Следующее
От: Doug McNaught
Дата:
Сообщение: Re: max_expr_depth