[PERFORM] Howto Increased performace ?

I used postgresql 7.3.2-1 with RH 9 on a mechine of 2 Xeon 3.0 Ghz and ram of 4 Gb. Since 1 1/2 yr. when I started to use the database server after optimizing the postgresql.conf everything went fine until a couple of weeks ago , my database grew up to 3.5 Gb and there were more than 140 concurent

[PERFORM] Speed in V8.0

Hello, i have a problem between V7.4.3 Cygwin and V8.0RC2 W2K. I have 2 systems: 1. Production Machine - Dual P4 3000MHz - 2 GB RAM - W2K - PostgreSQL 7.4.3 under Cygwin - i connect to it over a DSL Line 2. Develop Machine - P4 1800MHz - 760 MB RAM - PostgreSQL

Re: [PERFORM] Speed in V8.0

2. Develop Machine - P4 1800MHz - 760 MB RAM - W2K - PostgreSQL 8.0 RC2 Native Windows - local connection 100MB/FD - Thomas Wegner CabrioMeter - The Weather Plugin for Trillian http://www.wegner24.de/cabriometer Thomas Wegner [EMAIL

Re: [PERFORM] Speed in V8.0

Another man working to the bitter end this Christmas! There could be many reasons, but maybe first you should look at the amount of RAM available? If the tables fit in RAM on the production server but not on the dev server, then that will easily defeat the improvement due to using the native DB

Re: [PERFORM] Howto Increased performace ?

On Tue, 2004-12-21 at 16:31 +0700, Amrit Angsusingh wrote: I used postgresql 7.3.2-1 with RH 9 on a mechine of 2 Xeon 3.0 Ghz and ram of 4 Gb. Since 1 1/2 yr. when I started to use the database server after optimizing the postgresql.conf everything went fine until a couple of weeks ago , my

Re: [PERFORM] Speed in V8.0

On Wed, 2004-12-22 at 00:03 +0100, Thomas Wegner wrote: Hello, i have a problem between V7.4.3 Cygwin and V8.0RC2 W2K. I have 2 systems: 1. Production Machine - Dual P4 3000MHz - 2 GB RAM - W2K - PostgreSQL 7.4.3 under Cygwin - i connect to it over a DSL Line 2.