Обсуждение: Reference data for performance testing?
Hello, We're evaluating postgresql as a backend choice for our next generation software and would like to perform some rough measurements in-house. Where could I get my hands on some reference data, say few very large tables with a total size of over 1G that we could run. I noticed earlier discussion about Tiger data, but 30G is a bit too much for what we need. Any other ideas or suggestions? Thanks. -- -Boris
Boris, > We're evaluating postgresql as a backend choice for our next > generation software and would like to perform some rough measurements > in-house. Where could I get my hands on some reference data, say few > very large tables with a total size of over 1G that we could run. I > noticed earlier discussion about Tiger data, but 30G is a bit too much > for what we need. Any other ideas or suggestions? The same discussion references the FCC data, which is more managably sized. Please share your results, if you can! -- -Josh Berkus Aglio Database Solutions San Francisco
Hello Josh, Thursday, April 10, 2003, 10:22:50 AM, you wrote: JB> Boris, >> We're evaluating postgresql as a backend choice for our next >> generation software and would like to perform some rough measurements >> in-house. Where could I get my hands on some reference data, say few >> very large tables with a total size of over 1G that we could run. I >> noticed earlier discussion about Tiger data, but 30G is a bit too much >> for what we need. Any other ideas or suggestions? JB> The same discussion references the FCC data, which is more managably sized. JB> Please share your results, if you can! I can't find a link right now, could you tell me where can I download it? -- -Boris
On Thursday, April 10, 2003, at 01:20 PM, Boris Popov wrote: > We're evaluating postgresql as a backend choice for our next > generation software and would like to perform some rough measurements > in-house. Where could I get my hands on some reference data, say few > very large tables with a total size of over 1G that we could run. I > noticed earlier discussion about Tiger data, but 30G is a bit too much > for what we need. Any other ideas or suggestions? Actually Tiger is broken down into easily digestable chunks; you don't grab all 30G at once. Pick one moderate size state to work with and you've got about the right size data set.
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
-------------------------------------
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
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
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