From: | newsreader(at)mediaone(dot)net |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: I've followed the faq and still getting too many clients errr |
Date: | 2001-02-19 03:49:49 |
Message-ID: | 20010218224949.A18201@dragon.universe |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
not really!! too many clients already!!!
i've set def-maxbackends to 1024!!!
i've run out of all options.. it appears
i thought i would never see the day my load
average goes over 2.0 It's really painful
to see it's now at 30 or so..
On Sun, Feb 18, 2001 at 10:46:25PM -0500, newsreader(at)mediaone(dot)net wrote:
> not so fast! i did not pay attention to
> the message
> mount point /dev/shm does not exist
> when the kernel was loading
>
> we will see soon whether this problem
> is really solved...
>
> On Sun, Feb 18, 2001 at 10:26:23PM -0500, newsreader(at)mediaone(dot)net wrote:
> > wrong! still too many clients.. aaaaargh
> >
> > On Sun, Feb 18, 2001 at 10:09:33PM -0500, newsreader(at)mediaone(dot)net wrote:
> > >
> > > I trace the problem to kernel 2.4 -- I think.
> > > Appropriate section from kernel source
> > > documention is below.
> > >
> > > If anyone outthere is planning to upgrade linux kernel
> > > to 2.4 you might want to keep this in mind.
> > >
> > > It looks like all is well now... what a relief.
> > >
> > >
> > > --------------------------
> > > You can find documentation about IPC with "info ipc" and also in
> > > section 6.4 of the Linux Programmer's Guide, available from
> > > http://www.linuxdoc.org/docs.html#guide .
> > >
> > > Shared memory is now implemented using a new (minimal) virtual file
> > > system. To mount it automatically at system startup just add the
> > > following line to your /etc/fstab:
> > >
> > > none /dev/shm shm defaults 0 0
> > >
> > > Saying Y here enlarges your kernel by about 18 KB. Just say Y.
> > > ----------------------
> > >
> > >
> > >
> > >
> > > On Sun, Feb 18, 2001 at 08:22:24PM -0600, Dominic J. Eidson wrote:
> > > > On Sun, 18 Feb 2001 newsreader(at)mediaone(dot)net wrote:
> > > >
> > > > > I just change the following line in src/configure
> > > > > #define DEF_MAXBACKENDS 32
> > > > > to
> > > > > #define DEF_MAXBACKENDS 100
> > > > >
> > > > > Did I do that right? After ./configure I check
> > > > > src/include/config.h and see that previous number 32
> > > > > has been changed to 100.
> > > >
> > > > ./configure --with-maxbackends=100
> > > >
> > > > Should do the job.
> > > >
> > > >
> > > > --
> > > > Dominic J. Eidson
> > > > "Baruk Khazad! Khazad ai-menu!" - Gimli
> > > > -------------------------------------------------------------------------------
> > > > http://www.the-infinite.org/ http://www.the-infinite.org/~dominic/
From | Date | Subject | |
---|---|---|---|
Next Message | Lincoln Yeoh | 2001-02-19 03:59:01 | Re: I've followed the faq and still getting too many clients errr |
Previous Message | newsreader | 2001-02-19 03:46:25 | Re: I've followed the faq and still getting too many clients errr |