Re: [GENERAL] Memory requirements for web-project

2001-02-04 Thread Richard Huxton
Other people have said a lot on this, but IMHO missed some key points Boris wrote: > > Hello pgsql-general, > > i need to calculate the memory requirement if i am using apache+pgsql. > > Lets assume that i want 160.000 hits a day and pgsql takes 3 seconds > to work for each client, how much ra

Re: [GENERAL] can't run on TCP/IP ports

2001-02-04 Thread Oliver Elphick
Patrick Raphael wrote: > >I figured out the problem, postmaster when run as postgres didn't have >write permissions to /var/run/postgresql directory (where the Debian >version puts its socket files) and therefore didn't have permission to >open the socket. . What Debian version of post

Re: [GENERAL] Solaris 8 compilation errors

2001-02-04 Thread Alex Guryanow
JG> I don't see Solaris 8 on the list of supported platforms, I have compiled postgres 7.0.3 on SPARC/Solrais 8. But it was compiled w/o tcl support. There is no much time since installation, but yet all works fine. JG> but Solaris 7 is JG> there, so I had hoped 8 would work pretty much the

Re: [GENERAL] Strage behavior

2001-02-04 Thread Tom Lane
Fernando Schapachnik <[EMAIL PROTECTED]> writes: > select * from aliases where alias~'^claudia.gonzalez$' \g > alias|receptores > -+-- > (0 rows) > select * from aliases where alias~'claudia.gonzalez$' \g > alias |receptores > +-- > claudia.gonzal

Re: [GENERAL] 7.1beta4 initdb problem

2001-02-04 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Tim Barnard writes: >> The program '/usr/local/pgsql/bin/postgres' needed by initdb does not >> belong to PostgreSQL version 7.1beta4. Check your installation. > Can you run 'sh -x initdb ...' and show me the output? Some platform > information woul

Re: [GENERAL] can't run on TCP/IP ports

2001-02-04 Thread Tom Lane
Patrick Raphael <[EMAIL PROTECTED]> writes: > I figured out the problem, postmaster when run as postgres didn't have > write permissions to /var/run/postgresql directory (where the Debian > version puts its socket files) and therefore didn't have permission to > open the socket. . ROTFL ... score

Re: [GENERAL] Re[2]: Memory requirements for web-project

2001-02-04 Thread Francisco Reyes
On Sun, 4 Feb 2001, Boris wrote: > That sounds good, the only question left is the memory requiremend of > apache per client, i do not completely understand the spawning things > with Apache. On high load there are alway minimum 10 processes left, > but where is the limit? Interesting thing. I wo

[GENERAL] Re: Re[2]: Memory requirements for web-project

2001-02-04 Thread Lincoln Yeoh
At 06:13 PM 04-02-2001 +0100, Boris wrote: >LY> My guess is that your hits are likely to bunch up at certain times, rather >LY> than be spread out evenly (90% of the people behave similarly 90% of the >LY> time). So you might wish to multiply by 5 or 10 (or whatever you pluck from >LY> the air ;)