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

2005-02-11 Thread Brian B.
lue anywhere from a default doubling (of 128KB) up to around 1MB. Thanks, Brian B. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

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

2005-02-11 Thread Brian B.
On Fri, Feb 11, 2005 at 10:05:36PM -0500, Tom Lane wrote: > "Brian B." <[EMAIL PROTECTED]> writes: > > When setting the "LIBC_R" option, the FreeBSD port essentially sets CFLAGS > > to > > -D_THREAD_SAFE and LDFLAGS to -pthread. This is probably due

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

2005-02-11 Thread Brian B.
On Fri, Feb 11, 2005 at 09:46:50PM -0500, Tom Lane wrote: > "Brian B." <[EMAIL PROTECTED]> writes: > > I use the FreeBSD PostgreSQL port and I set the option to use threads so > > that pl/python will work with PostgreSQL. > > What option is that, exac

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

2005-02-11 Thread Brian B.
rt-specific patches. The same behavior occurs. So I am not sure if, again, it's my libc_r or something gets messed up in the PostgreSQL code dealing with the stack/recursion, when I have pthread libs linked in. I am guessing it is just my particular environment, though. Thanks, Brian B.

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

2005-02-11 Thread Brian B.
ose. I'm going to do a few tests to try to figure out what's going on with my environment and let you know if I come up with anything odd. Thanks for your time! Brian B. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

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

2005-02-11 Thread Brian B.
Using gcc 2.95.4. I will eliminate all the optimization options when I recompile PostgreSQL and see what happens. Thanks, Brian B. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail comm

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

2005-02-11 Thread Brian B.
27;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. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

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

2005-02-10 Thread Brian B.
h around that point. I will try to narrow down what query is being ran at that point. Perhaps I can extract it from the core dump. Thanks, Brian B. ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

[BUGS] BUG #1473: Backend bus error, possibly due to ANALYZE

2005-02-09 Thread Brian B.
The following bug has been logged online: Bug reference: 1473 Logged by: Brian B. Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: FreeBSD 4.11-STABLE Description:Backend bus error, possibly due to ANALYZE Details: Hello, I am loading