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(at)gmail(dot)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(at)gmail(dot)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
> >
>