pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
update query blows out
4+ messages / 2 participants
[nested] [flat]

* update query blows out
@ 2003-04-12 17:14  shane hill <shill@adobe.com>
  0 siblings, 1 reply; 4+ messages in thread

From: shane hill @ 2003-04-12 17:14 UTC (permalink / raw)
  To: pgsql-performance

Hi folks,   sorry if the following is confusing, I have just tried to 
provide the pertinent info and I have been up for more than 24 hours 
working. I am getting weary....

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.

I assumed this was related to the shared memory settings but when I 
tried changing those values the behavior was identical. I did not try 
beyond 256 megs for  shmmax.
I then tried the temporary solution of lowering the number of 
shared_buffers and max_connections but that did not change anything either.
I then tried using the IN operator but that did not change anything either

I am wondering if there is some other limit that I am hitting in MacOSX 
that is not related to the SHM vars.

I hope I am just overlooking something simple and that the list will 
come back with some chiding and an answer :)

does anybody have any suggestions?

thank you very much,

-Shane


-----------------------------------------------------------
SQL DETAILS:

my query is of this form:

BEGIN;

UPDATE "mytable" SET "n_filtered"=0,"n_dirty"=1 where ("s_fileName" = 
'filename1' OR "s_fileName" = 'filename2' ....... OR "s_fileName" = 
'filename2000') AND ("n_objId=12345);

COMMIT;

explain tells me this:

seq scan on "mytable" (cost=0.00..5020.00 rows=5 width=174)  Filter 
 .........

-----------------------------------------------------------

-----------------------------------------------------------
SYSTEM:

os:           Mac 10.2.4
chip:        1.4 GHz
ram:        1 GB
-----------------------------------------------------------

-----------------------------------------------------------
ERROR MESSAGE:

server process (pid 650) was terminated by signal 11
all server processes terminated; reinitializing shared memopry and 
semaphores

-----------------------------------------------------------

-----------------------------------------------------------
SOLUTIONS I HAVE TRIED

1. tweaking the five kern.sysv vars. to every configurable option possible

currently I am at:

kern.sysv.shmmax: 1073741824
kern.sysv.shmmin: 256
kern.sysv.shmmni: 8192
kern.sysv.shmseg: 2048
kern.sysv.shmall: 262144

(I know shmmin is way too high according to the stuff I read, I was just 
getting desperate, I have tried just leaving it at 1)


2. lowering the number of shared_buffers and  max_connections to 32:16 
32:8 16:8 in postgresql.conf

currently I am at 64 shared_bufs  and 32 max_connects (these were the 
defaults)

3. Using the IN sql operator rather than a bunch of ORs, but I still 
have the same problem

-------------------------------------




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: update query blows out
@ 2003-04-12 17:16  Tom Lane <tgl@sss.pgh.pa.us>
  parent: shane hill <shill@adobe.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Tom Lane @ 2003-04-12 17:16 UTC (permalink / raw)
  To: shane hill <shill@adobe.com>; +Cc: pgsql-performance

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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: update query blows out
@ 2003-04-12 18:14  shane hill <shill@adobe.com>
  parent: Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 4+ messages in thread

From: shane hill @ 2003-04-12 18:14 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: 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
>
>
>  
>

Attachments:

postmaster.crash.log (text/plain, 33.0K) download 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
^ permalink raw reply [nested|flat] 4+ messages in thread

* Re: update query blows out
@ 2003-04-12 20:53  Tom Lane <tgl@sss.pgh.pa.us>
  parent: shane hill <shill@adobe.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Tom Lane @ 2003-04-12 20:53 UTC (permalink / raw)
  To: shane hill <shill@adobe.com>; +Cc: pgsql-performance

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.

> [ core dump in heavily-recursive routine ]

I think you are running into a stack-size problem.  A quick look at
"ulimit -a" on my own OS X machine shows that the default stack limit
is a mere 512KB, which is verging on the ridiculously small :-(.

Try setting "ulimit -s 10000" or so in the script that launches the
postmaster.  Now that I look at it, the -d setting is on the miserly
side as well ...

			regards, tom lane




^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2003-04-12 20:53 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-04-12 17:14 update query blows out shane hill <shill@adobe.com>
2003-04-12 17:16 ` Tom Lane <tgl@sss.pgh.pa.us>
2003-04-12 18:14   ` shane hill <shill@adobe.com>
2003-04-12 20:53     ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox