X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6BCDF3A5436 for ; Mon, 24 Jan 2005 09:23:20 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 74308-10 for ; Mon, 24 Jan 2005 09:23:07 +0000 (GMT) Received: from devel.greip.ee (devel.greip.ee [194.126.99.220]) by svr1.postgresql.org (Postfix) with ESMTP id 0ACA03A5409 for ; Mon, 24 Jan 2005 09:23:05 +0000 (GMT) Received: from [192.168.40.64] (unknown [192.168.40.64]) by devel.greip.ee (Postfix) with ESMTP id 7907C1B705; Mon, 24 Jan 2005 11:23:03 +0200 (EET) Message-ID: <41F4BE45.4040402@uptime.ee> Date: Mon, 24 Jan 2005 11:22:13 +0200 From: Andrei Reinus User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.5) Gecko/20041222 X-Accept-Language: en-us, en MIME-Version: 1.0 To: SpaceBallOne Cc: pgsql-performance@postgresql.org Subject: Re: poor performance of db? References: In-Reply-To: X-Enigmail-Version: 0.89.6.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: multipart/mixed; boundary="------------070205050907030705000202" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200501/435 X-Sequence-Number: 10125 This is a multi-part message in MIME format. --------------070205050907030705000202 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit SpaceBallOne wrote: > Hello everyone, > > First time poster to the mailing list here. > > We have been running pgsql for about a year now at a pretty basic > level (I guess) as a backend for custom > web (intranet) application software. Our database so far is a "huge" > (note sarcasm) 10 Mb containing of about 6 or so principle tables. > > Our 'test' screen we've been using loads a 600kb HTML document which > is basically a summary of our client's orders. It took originally 11.5 > seconds to load in internet explorer (all 10.99 seconds were pretty > much taken up by postgres processes on a freebsd server). > > I then re-wrote the page to use a single select query to call all the > information needed by PHP to draw the screen. That managed to shave it > down to 3.5 seconds... but this so far is as fast as I can get the > page to load. Have tried vacuuming and creating indexes but to no > avail. (increasing shared mem buffers yet to be done) > > Now heres the funny bit ... > > Every time I tested an idea to speed it up, I got exactly the same > loading time on a Athlon 1800+, 256Mb RAM, 20Gb PATA computer as > compared to a Dual Opteron 246, 1Gb RAM, 70Gb WD Raptor SATA server. > Now, why a dual opteron machine can't perform any faster than a lowly > 1800+ athlon in numerous tests is completely beyond me .. increased > memory and RAID 0 disc configurations so far have not resulted in any > significant performance gain in the opteron server. > > Do these facts sound right? If postgres is meant to be a 200Gb > industrial strength database, should it really be taking this long > pulling 600kb worth of info from a 10Mb database? And why no > performance difference between two vastly different hardware spec'd > computers??? Am I missing some vital postgres.conf setting?? > > Any advice welcome. > > Thanks, > Dave > space_ball_one@hotmail.com > Could you give us a bit more info. What you are trying to do. EXPLAIN ANALYZE would be great. In my experience first problem with the first db app is no indexes used in joining. -- -- Andrei Reinus --------------070205050907030705000202 Content-Type: text/x-vcard; charset=utf-8; name="andrei.reinus.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="andrei.reinus.vcf" begin:vcard fn:Andrei Reinus n:Reinus;Andrei org;quoted-printable:Uptime O=C3=9C;GreipCRM adr:;;Kompani 1C;Tartu;Tartu;;Estonia email;internet:andrei.reinus@uptime.ee title:Spetsiaaltarkvara arendaja tel;cell:+37253460005 x-mozilla-html:TRUE url:http://www.uptime.ee version:2.1 end:vcard --------------070205050907030705000202--