Re: Where do a novice do to make it run faster? - Mailing list pgsql-performance

From Claus Guttesen
Subject Re: Where do a novice do to make it run faster?
Date
Msg-id b41c75520804280919l4548b749r45b68ef870ff7329@mail.gmail.com
Whole thread Raw
In response to Where do a novice do to make it run faster?  ("A B" <gentosaker@gmail.com>)
List pgsql-performance
>  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

pgsql-performance by date:

Previous
From: Gaetano Mendola
Date:
Subject: shared_buffer/DRBD performances
Next
From: Andrew Sullivan
Date:
Subject: Re: Replication Syatem