Ok, i installed the 7.4.3 on the dev machine under Cygwin and the was 4 times slower than the V8. They need 394 seconds. Whats wrong with my dev machine. There was enough free memory available. --------------------------------------------- Thomas Wegner CabrioMeter - The Weather Plugin for Trillian http://www.wegner24.de/cabriometer
""Matt Clark"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] > 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 version. > > Why don't you install cygwin on the dev box and do the comparison using > the > same hardware? > > M > >> -----Original Message----- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On Behalf Of >> Thomas Wegner >> Sent: 21 December 2004 23:03 >> To: pgsql-performance@postgresql.org >> Subject: [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 Native Windows >> - local connection 100MB/FD >> >> Both systems use the default postgresql.conf. Now the >> problem. I have an (unoptimized, dynamic) query wich was >> execute on the production machine over DSL in 2 seconds and >> on my develop machine, connected over local LAN, in 119 seconds! >> >> Whats this? I can not post the query details here public, its >> a commercial project. Any first idea? I execute on both >> machine the same query with the same database design! >> --------------------------------------------- >> Thomas Wegner >> CabrioMeter - The Weather Plugin for Trillian >> http://www.wegner24.de/cabriometer >> >> >> >> ---------------------------(end of >> broadcast)--------------------------- >> TIP 4: Don't 'kill -9' the postmaster >> > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
