DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=DO7bCXjMdNnbAWEt0ZkCWeNuMZP1b3eImMmnuMepwffNj/g/W688gzyxotNKnYsmU+qJcX/4LpC54JPf3nDKlVzKMr/Tmi+JqhqPofRvOZ3C8qD8721oMG94zSrIHCrtBbTMswFJ1QigrSEy1VOrK2/EdvhN1BjqasrGdRa10mg=
Message-ID: <dbbf25900804290209y7924b5b3m3d3f2d305acdb171@mail.gmail.com>
Date: Tue, 29 Apr 2008 11:09:48 +0200
From: "A B" <gentosaker@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: Where do a novice do to make it run faster?
In-Reply-To: <dbbf25900804290009k55c68998p8509c88823104ade@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <dbbf25900804280856m41c67d96heaa616d39d6c44e0@mail.gmail.com>
	<b41c75520804280919l4548b749r45b68ef870ff7329@mail.gmail.com>
	<dbbf25900804290009k55c68998p8509c88823104ade@mail.gmail.com>

Here is some more information.

Size of database:

du -sh /var/lib/pgsql/data/base/*
4,1M    /var/lib/pgsql/data/base/1
4,1M    /var/lib/pgsql/data/base/10792
4,1M    /var/lib/pgsql/data/base/10793
9,1M    /var/lib/pgsql/data/base/16388
11M     /var/lib/pgsql/data/base/19233
1,6G    /var/lib/pgsql/data/base/20970

I'm not sure what the size acctually is... But I can't imagine that it
is 1,6 GB!!! I'd say I have 11MB of data in it...

Cpu is Intel CoreDuo E6750, 4 GB RAM
Harddiscs are two Segate 320 GB SATA discs. running software raid
(!!), raid-1.Yes, this might be a big performance hit, but that is
what I have right now, in the future I can throw more money on
hardware.

Will I see a general improvement in performance in 8.3.X over 8.1.11?


2008/4/29 A B <gentosaker@gmail.com>:
> Right now, version 8.1.11 on centos.x86-64, intel dual core cpu with 2
>  sata discs  (mirror raid)
>
>  The queries are most select/inserts.. I guess... I'm not sure exactly
>  what to answer on that.
>  "explain analyze" is something I have not read about yet.
>
>
>  2008/4/28 Claus Guttesen <kometen@gmail.com>:
>
>
> > >  1) hardware
>  >  >  2) rewriting my queries and table structures
>  >  >  3) using more predefined queries
>  >  >  4) tweek parameters in the db conf files
>  >  >
>  >  >  Of these points:
>  >  >  1) is nothing I can do about right now, but in the future perhaps.
>  >  >  2) will be quite hard right now since there is more code than time.
>  >  >  3) almost like 2 but perhaps more do-able with the current constraints.
>  >  >  4) This seems to be the easiest one to start with...
>  >  >
>  >  >  So what should I do/read concerning point 4?
>  >  >  If you have other good suggestions  I'd be very interested in that.
>  >  >
>  >  >  Thank you :-)
>  >
>  >  You can provide information postgresql-version, what type of queries
>  >  you're running, some explain analyze of those, and what type of
>  >  hardware you're running and what OS is installed.
>  >
>  >  --
>  >  regards
>  >  Claus
>  >
>  >  When lenity and cruelty play for a kingdom,
>  >  the gentlest gamester is the soonest winner.
>  >
>  >  Shakespeare
>  >
>