Re: Where do a novice do to make it run faster?

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