Re: max_expr_depth - Mailing list pgsql-general

From Doug McNaught
Subject Re: max_expr_depth
Date
Msg-id m3r8whb4o7.fsf@belphigor.mcnaught.org
Whole thread Raw
In response to max_expr_depth  (Joseph Shraibman <jks@selectacast.net>)
List 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 by date:

Previous
From: "Dave Cramer"
Date:
Subject: Re: Error: RelationBuildTriggers: 2 record(s) not found for rel customerinfo
Next
From: Doug McNaught
Date:
Subject: Re: max_expr_depth