Re: update query blows out - Mailing list pgsql-performance

From shane hill
Subject Re: update query blows out
Date
Msg-id 3E98579F.8040904@adobe.com
Whole thread Raw
In response to Reference data for performance testing?  (Boris Popov <boris@procedium.com>)
Responses Re: update query blows out
List pgsql-performance
Postgres 7.3.1

The crash log is attached:

thank you very much!

-Shane


Tom Lane wrote:

>shane hill <shill@adobe.com> writes:
>
>
>>I am having a problem with an update transaction. I need to update 4000+
>>records but the update query keeps blowing out postgres and at times I
>>am forced to restart the postmaster or reboot my server if I update
>>2500+ records. The query is fine with 2225 records it is just somewhere
>>beyond 2225 that brings the server down.
>>
>>
>
>What Postgres version?  Can you get a backtrace from the core dump?
>
>            regards, tom lane
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org
>
>
>
>


Date/Time:  2003-04-11 22:44:26 -0700
OS Version: 10.2.4 (Build 6I35)
Host:       qesx

Command:    postmaster
PID:        622

Exception:  EXC_BAD_ACCESS (0x0001)
Codes:      KERN_INVALID_ADDRESS (0x0001) at 0xbff7ffc0

Thread 0 Crashed:
 #0   0x000acb88 in eval_const_expressions_mutator (clauses.c:1130)
 #1   0x000add34 in expression_tree_mutator (clauses.c:2314)
 #2   0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #3   0x000add34 in expression_tree_mutator (clauses.c:2314)
 #4   0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #5   0x000add34 in expression_tree_mutator (clauses.c:2314)
 #6   0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #7   0x000add34 in expression_tree_mutator (clauses.c:2314)
 #8   0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #9   0x000add34 in expression_tree_mutator (clauses.c:2314)
 #10  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #11  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #12  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #13  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #14  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #15  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #16  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #17  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #18  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #19  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #20  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #21  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #22  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #23  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #24  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #25  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #26  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #27  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #28  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #29  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #30  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #31  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #32  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #33  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #34  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #35  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #36  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #37  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #38  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #39  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #40  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #41  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #42  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #43  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #44  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #45  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #46  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #47  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #48  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #49  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #50  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #51  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #52  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #53  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #54  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #55  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #56  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #57  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #58  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #59  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #60  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #61  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #62  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #63  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #64  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #65  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #66  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #67  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #68  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #69  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #70  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #71  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #72  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #73  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #74  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #75  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #76  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #77  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #78  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #79  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #80  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #81  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #82  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #83  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #84  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #85  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #86  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #87  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #88  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #89  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #90  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #91  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #92  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #93  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #94  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #95  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #96  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #97  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #98  0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #99  0x000add34 in expression_tree_mutator (clauses.c:2314)
 #100 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #101 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #102 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #103 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #104 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #105 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #106 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #107 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #108 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #109 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #110 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #111 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #112 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #113 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #114 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #115 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #116 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #117 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #118 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #119 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #120 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #121 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #122 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #123 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #124 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #125 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #126 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #127 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #128 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #129 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #130 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #131 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #132 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #133 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #134 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #135 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #136 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #137 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #138 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #139 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #140 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #141 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #142 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #143 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #144 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #145 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #146 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #147 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #148 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #149 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #150 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #151 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #152 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #153 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #154 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #155 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #156 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #157 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #158 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #159 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #160 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #161 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #162 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #163 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #164 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #165 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #166 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #167 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #168 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #169 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #170 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #171 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #172 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #173 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #174 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #175 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #176 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #177 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #178 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #179 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #180 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #181 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #182 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #183 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #184 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #185 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #186 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #187 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #188 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #189 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #190 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #191 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #192 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #193 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #194 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #195 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #196 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #197 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #198 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #199 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #200 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #201 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #202 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #203 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #204 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #205 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #206 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #207 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #208 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #209 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #210 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #211 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #212 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #213 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #214 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #215 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #216 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #217 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #218 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #219 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #220 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #221 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #222 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #223 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #224 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #225 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #226 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #227 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #228 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #229 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #230 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #231 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #232 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #233 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #234 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #235 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #236 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #237 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #238 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #239 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #240 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #241 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #242 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #243 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #244 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #245 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #246 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #247 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #248 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #249 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #250 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #251 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #252 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #253 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #254 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #255 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #256 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #257 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #258 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #259 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #260 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #261 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #262 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #263 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #264 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #265 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #266 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #267 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #268 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #269 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #270 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #271 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #272 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #273 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #274 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #275 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #276 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #277 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #278 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #279 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #280 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #281 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #282 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #283 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #284 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #285 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #286 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #287 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #288 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #289 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #290 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #291 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #292 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #293 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #294 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #295 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #296 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #297 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #298 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #299 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #300 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #301 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #302 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #303 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #304 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #305 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #306 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #307 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #308 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #309 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #310 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #311 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #312 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #313 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #314 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #315 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #316 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #317 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #318 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #319 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #320 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #321 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #322 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #323 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #324 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #325 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #326 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #327 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #328 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #329 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #330 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #331 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #332 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #333 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #334 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #335 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #336 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #337 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #338 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #339 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #340 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #341 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #342 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #343 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #344 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #345 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #346 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #347 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #348 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #349 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #350 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #351 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #352 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #353 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #354 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #355 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #356 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #357 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #358 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #359 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #360 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #361 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #362 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #363 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #364 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #365 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #366 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #367 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #368 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #369 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #370 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #371 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #372 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #373 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #374 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #375 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #376 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #377 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #378 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #379 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #380 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #381 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #382 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #383 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #384 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #385 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #386 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #387 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #388 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #389 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #390 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #391 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #392 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #393 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #394 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #395 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #396 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #397 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #398 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #399 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #400 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #401 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #402 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #403 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #404 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #405 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #406 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #407 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #408 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #409 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #410 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #411 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #412 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #413 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #414 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #415 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #416 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #417 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #418 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #419 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #420 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #421 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #422 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #423 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #424 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #425 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #426 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #427 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #428 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #429 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #430 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #431 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #432 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #433 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #434 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #435 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #436 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #437 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #438 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #439 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #440 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #441 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #442 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #443 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #444 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #445 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #446 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #447 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #448 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #449 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #450 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #451 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #452 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #453 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #454 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #455 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #456 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #457 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #458 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #459 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #460 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #461 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #462 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #463 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #464 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #465 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #466 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #467 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #468 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #469 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #470 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #471 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #472 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #473 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #474 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #475 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #476 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #477 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #478 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #479 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #480 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #481 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #482 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #483 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #484 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #485 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #486 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #487 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #488 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #489 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #490 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #491 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #492 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #493 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #494 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #495 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #496 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #497 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #498 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #499 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #500 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #501 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #502 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #503 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #504 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #505 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #506 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)
 #507 0x000add34 in expression_tree_mutator (clauses.c:2314)
 #508 0x000acbb8 in eval_const_expressions_mutator (clauses.c:1149)

PPC Thread State:
  srr0: 0x000acb88 srr1: 0x0000d930                vrsave: 0x00000000
   xer: 0x20000000   lr: 0x000acb80  ctr: 0x000acb70   mq: 0x00000000
    r0: 0x000add34   r1: 0xbff80030   r2: 0x24024424   r3: 0x0157ff90
    r4: 0x00000000   r5: 0x000001f5   r6: 0x00001f40   r7: 0x0000000c
    r8: 0x00000000   r9: 0x01202b18  r10: 0x00000000  r11: 0x00000000
   r12: 0x000acb70  r13: 0x001a0c30  r14: 0x00afa008  r15: 0xbfffee60
   r16: 0x00000002  r17: 0x00000001  r18: 0x001a2dd4  r19: 0x0019e9d0
   r20: 0x00000002  r21: 0x001a6f84  r22: 0x00000000  r23: 0x00000000
   r24: 0x001a6f84  r25: 0x00000000  r26: 0x000acb70  r27: 0x00000000
   r28: 0x0157ff90  r29: 0x01581130  r30: 0x00000000  r31: 0x000acb80


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: update query blows out
Next
From: Tom Lane
Date:
Subject: Re: update query blows out