Hi!
On 29-Nov-99 The Hermit Hacker wrote:
>> Yes! But I recommend backend pool too. What is it? The postmaster task
>> runs now backend for each query. Good. But After query backend
>> finished. I recommend to stay backend running within a some timeout.
>> If the next query occured the postmaster redirect query to any idle
>> backend or run a new one unless. Then backend serve some connections
>> it shut down itself, this prevents memory leaks.
>>
>> Using this method we can get same speed like as with threads.
>
> Actually, with how fast Bruce has been able to get the start time on a
> backend process, I seriously doubt that you'll get much more of a speed
> up, but if you wish to work on creating a 'backend pool' of processes, I
> don't think anyone will complain...
When I got more free time... I have no it. Making backend pool is not hard to
program basically but I need to change backend startup/finish code because it
will not nessesary to allocate/free buffers etc... only flush/clear.
I didnt hack so deep ;-) for this db...
I'm thinking...
>> I hope my postgresql will be faster when I install more RAM :-(
>
> What version of PostgreSQL are you currently running? From a previous
> message, I'm suspecting v6.3, which, compared to current releases, is
> slow...
>
> The other thing...how much RAM are you currently running? What startup
> options? What operating system? Hardware? If you are running SCSI
> drive, great...if IDE, that's one major bottleneck there...
I run postgresql 6.5 on Linux 2.0.36. Wide-SCSI HDD, 128Mb ECC RAM.
Db starts as:
#!/bin/sh
#
PGACCOUNT=postgres
#
export PATH=$PATH:/usr/comset/dbase/bin
export MANPAT=$MANPATH:/usr/comset/dbase/man
export PGLIB=/usr/comset/dbase/lib
export PGDATA=/usr/comset/dbase/data
export LANG=ru_RU.KOI8-R
export LC_CTYPE=ru_RU.KOI8-R
export LC_COLLATE=ru_RU.KOI8-R
POSTMASTER="/usr/comset/dbase/bin/postmaster"
PGLOGFILE="/usr/comset/dbase/log/postgres.log"
PGOPTS="-i -D/usr/comset/dbase/data -o \"-F -e\""
echo "${POSTMASTER} ${PGOPTS}"
${POSTMASTER} -i -D/usr/comset/dbase/data -d 1 -o "-F -e" 2>&1 >>${PGLOGFILE}
So, it runs via
/usr/comset/dbase/bin/postmaster -i -D/usr/comset/dbase/data -o "-F -e"
By default in general...
And... I run apache web-server on same computer. :-(
Apache uses PHP3 linked with postgresql.
SKiller
--------------------------
Sergei Keler
WebMaster of "ComSet"
E-Mail: [EMAIL PROTECTED]
http://www.comset.net
--------------------------
************
