From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: Max backend limits cleaned up |
Date: | 1999-02-21 03:47:55 |
Message-ID: | 28740.919568875@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I did a little more work on the configurable-max-backends patch:
1. initdb didn't work because I had broken bootstrap mode :-(.
Fixed.
2. I separated the hard maximum limit on the number of backends
(MAXBACKENDS, used to size a couple of arrays) from the default
soft limit (now DEF_MAXBACKENDS).
3. The only cost of enlarging MAXBACKENDS is about 32 bytes per
array slot, so I set MAXBACKENDS at 1024 while leaving the
default DEF_MAXBACKENDS at 64. (I more than bought back the 32K
by reducing the number of allocated spinlocks to what we were
actually using, anyway.)
4. Upshot: default limit on number of backends is 64, same as it
ever was, but you can set it as high as 1024 without a recompile.
Just start the postmaster with desired -N switch. (Of course you
might need to reconfigure your kernel first ;-).)
5. Allocation of semaphores and shared memory is now based on
-N switch value (default or specified) rather than the MAXBACKENDS
constant.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-02-21 03:59:12 | Re: [HACKERS] Re: Max backend limits cleaned up |
Previous Message | Tom Lane | 1999-02-20 21:48:52 | Re: [HACKERS] Major bug, possible, with Solaris 7? |