[GENERAL] postgresql 8 abort with signal 10

2005-05-03 Thread Alexandre Biancalana
Hi list, I'm running postgresql 8.0.1 on FreeBSD 4.11-STABLE, the machine is and AMD Sempron 2.2, 1GB Ram.. I use postgresql as database for dspam, an spam classification program. This database have and moderated use, on averange 10 simultaneous conections executing relative big queries using "

Re: [GENERAL] postgresql 8 abort with signal 10

2005-05-03 Thread Alexandre Biancalana
>>You need to find out what's triggering that. Turning on query logging >>would be a good way of investigating. Which directives can I use to enable this ? debug_print_parse ? debug_print_rewritten ? debug_print_plan ? debug_pretty_print ? >>Rather large, shared buffers for a machine with only

Re: [GENERAL] postgresql 8 abort with signal 10

2005-05-03 Thread Alexandre Biancalana
On 5/3/05, Scott Marlowe <[EMAIL PROTECTED]> wrote: > On Tue, 2005-05-03 at 11:36, Alexandre Biancalana wrote: > > >>You need to find out what's triggering that. Turning on query logging > > >>would be a good way of investigating. > > &g

Re: [GENERAL] postgresql 8 abort with signal 10

2005-05-03 Thread Alexandre Biancalana
Thank you for the detailed explanation Scott, they are very handy !! I reduced the shared_buffers to 32768, but the problem still occurs. Any other idea ?? ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister co

Re: [GENERAL] postgresql 8 abort with signal 10

2005-05-03 Thread Alexandre Biancalana
Ohhh god :( The FreeBSD is the last STABLE version. I can try to change some hardware, I already changed memory, what can I try now ? the processor ? motherboard ?? On 5/3/05, Scott Marlowe <[EMAIL PROTECTED]> wrote: > On Tue, 2005-05-03 at 15:04, Alexandre Biancalana wrote: >

Re: [GENERAL] postgresql 8 abort with signal 10

2005-06-02 Thread Alexandre Biancalana
> > hardware, I already changed memory, what can I try now ? the processor > > ? motherboard ?? > > > On 5/3/05, Scott Marlowe <[EMAIL PROTECTED]> wrote: > > > On Tue, 2005-05-03 at 15:04, Alexandre Biancalana wrote: > > > > Thank you for the detailed expl