From: A B <gentosaker@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: Where do a novice do to make it run faster?
Date: Tue, 29 Apr 2008 11:09:48 +0200
Message-ID: <dbbf25900804290209y7924b5b3m3d3f2d305acdb171@mail.gmail.com> (raw)
In-Reply-To: <dbbf25900804290009k55c68998p8509c88823104ade@mail.gmail.com>
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
> >
>
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: gentosaker@gmail.com
Subject: Re: Where do a novice do to make it run faster?
In-Reply-To: <dbbf25900804290209y7924b5b3m3d3f2d305acdb171@mail.gmail.com>
* 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