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 "
>>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
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
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
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:
>
> > 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