pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andrei Reinus <andrei.reinus@uptime.ee>
To: SpaceBallOne <space_ball_one@hotmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: poor performance of db?
Date: Mon, 24 Jan 2005 11:22:13 +0200
Message-ID: <41F4BE45.4040402@uptime.ee> (raw)
In-Reply-To: <BAY14-DAV850511937A7C1DDE0806FCC850@phx.gbl>
References: <BAY14-DAV850511937A7C1DDE0806FCC850@phx.gbl>

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 <mailto: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

Attachments:

andrei.reinus.vcf (text/x-vcard, 288B) download 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

view thread (8+ messages)  latest in thread

Message-ID: <41F4BE45.4040402@uptime.ee>
Permalink:  ../41F4BE45.4040402@uptime.ee/
Also on:    postgresql.org/message-id/41F4BE45.4040402@uptime.ee

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: andrei.reinus@uptime.ee, space_ball_one@hotmail.com
  Subject: Re: poor performance of db?
  In-Reply-To: <41F4BE45.4040402@uptime.ee>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox