From: | "Claus Guttesen" <kometen(at)gmail(dot)com> |
---|---|
To: | "A B" <gentosaker(at)gmail(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Where do a novice do to make it run faster? |
Date: | 2008-04-28 16:19:30 |
Message-ID: | b41c75520804280919l4548b749r45b68ef870ff7329@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Gaetano Mendola | 2008-04-28 16:19:48 | shared_buffer/DRBD performances |
Previous Message | Dennis Muhlestein | 2008-04-28 16:10:35 | Re: Where do a novice do to make it run faster? |