Skip site navigation (1) Skip section navigation (2)

Re: BUG #1473: Backend bus error, possibly due to ANALYZE

From: "Brian B(dot)" <brian-pgsql(at)bbdab(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1473: Backend bus error, possibly due to ANALYZE
Date: 2005-02-11 14:45:41
Message-ID: 20050211144541.GA24463@bbdab.org (view raw or flat)
Thread:
Lists: pgsql-bugs
On Thu, Feb 10, 2005 at 05:24:12PM -0500, Tom Lane wrote:
> Hmm, 64meg should certainly be far past where check_stack_depth will
> start to complain, so there's something else going on here.  (BUT:
> the ulimits you see interactively aren't necessarily what the postmaster
> was started under.  You might want to confirm that the results are the
> same if you put the limits call into the boot script that launches
> the postmaster...)
I put limits in the startup script for PostgreSQL and came up with the same
64MB stacksize value.

> See debug_query_string.
I've got the gdb output of printing debug_query_string and the text saved
from script(1) is about 267KB in size. Should I send this to you off-list?


Thanks,

Brian B.

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2005-02-11 15:07:04
Subject: Re: BUG #1466: #maintenace_work_mem = 16384
Previous:From: Magnus HaganderDate: 2005-02-11 11:54:18
Subject: Re: BUG #1466: #maintenace_work_mem = 16384

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group