X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 7A6CAD1BA56 for ; Wed, 3 Sep 2003 14:36:40 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 07831-08 for ; Wed, 3 Sep 2003 11:36:33 -0300 (ADT) Received: from smtp.pspl.co.in (unknown [202.54.11.65]) by svr1.postgresql.org (Postfix) with ESMTP id E0100D1B991 for ; Wed, 3 Sep 2003 11:36:28 -0300 (ADT) Received: (from root@localhost) by smtp.pspl.co.in (8.12.9/8.12.9) id h83Egmk1017269 for ; Wed, 3 Sep 2003 20:12:48 +0530 Received: from daithan (daithan.intranet.pspl.co.in [192.168.7.161]) (authenticated bits=0) by persistent.co.in (8.12.9/8.12.9) with ESMTP id h83EglCO017244 for ; Wed, 3 Sep 2003 20:12:47 +0530 From: "Shridhar Daithankar" To: pgsql-performance@postgresql.org Date: Wed, 03 Sep 2003 20:08:32 +0530 MIME-Version: 1.0 Subject: Re: PostgreSQL is slow...HELP Reply-To: shridhar_daithankar@persistent.co.in Message-ID: <3F564A40.3974.6561CEC@localhost> In-reply-to: <20030903130857.5986.qmail@web40401.mail.yahoo.com> X-mailer: Pegasus Mail for Windows (v4.12a) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/21 X-Sequence-Number: 3387 On 3 Sep 2003 at 6:08, Azlin Ghazali wrote: > Hi, > > I'm working on a project to make an application run on MySQL and PostgreSQL. > I find that PostgreSQL runs up to 10 times slower than MySQL. For small records > it is not much problems. But as the records grew (up to 12,000 records) the > difference is quite significant. We are talking about 15s (MySQL) vs 111s > (PostgreSQL). Someone suggest that my way of implementing PostgreSQL is not > efficient and someone out there might be able to help. > > FYI, I running the application on ASP, XP Professional and Pentium 4 machine. Are you running postgresql on windows? That's not an performance monster exactly? Is it under cygwin? BTW, did you do any performance tuning to postgresql? HTH Bye Shridhar -- Vulcans do not approve of violence. -- Spock, "Journey to Babel", stardate 3842.4