Re: [PERFORM] Basic Database Performance

2006-02-10 Thread PFC
We are running a prototype of a system running on PHP/Postgresql on an Intel Xeon 2ghz server, 1GB RAM, 40GB hard drive, I think this is a decent server... Now, I guess you are using Apache and PHP like everyone. Know these facts : - A client connection means an apach

Re: [PERFORM] Basic Database Performance

2006-02-10 Thread Markus Schaber
Hi, James, James Dey wrote: > Apologies if this is a novice queston, but I think it is a performance > one nevertheless. We are running a prototype of a system running on > PHP/Postgresql on an Intel Xeon 2ghz server, 1GB RAM, 40GB hard drive, > as a test bench. The system will be used for tens o

Re: [PERFORM] Basic Database Performance

2006-02-10 Thread James Dey
ubject: Re: [PERFORM] Basic Database Performance Don't forget to cc: the list. James Dey wrote: > Hi Richard, > > Firstly, thanks a million for the reply. > > To answer your questions: > 1. Are you limited by CPU, memory or disk i/o? > I am not limited, but would like to get

Re: [PERFORM] Basic Database Performance

2006-02-10 Thread Richard Huxton
Don't forget to cc: the list. James Dey wrote: Hi Richard, Firstly, thanks a million for the reply. To answer your questions: 1. Are you limited by CPU, memory or disk i/o? I am not limited, but would like to get the most out of the config I have in order to be able to know what I'll get, whe

Re: [PERFORM] Basic Database Performance

2006-02-10 Thread Richard Huxton
James Dey wrote: Apologies if this is a novice queston, but I think it is a performance one nevertheless. We are running a prototype of a system running on PHP/Postgresql on an Intel Xeon 2ghz server, 1GB RAM, 40GB hard drive, as a test bench. The system will be used for tens of thousands of use

[PERFORM] Basic Database Performance

2006-02-10 Thread James Dey
Hi Guys,   Apologies if this is a novice queston, but I think it is a performance one nevertheless. We are running a prototype of a system running on PHP/Postgresql on an Intel Xeon 2ghz server, 1GB RAM, 40GB hard drive, as a test bench. The system will be used for tens of thousands of us