Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Performance > Re: Where do a ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 8 Topic 4028 of 4424
Post > Topic >>

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

by kometen@[EMAIL PROTECTED] ("Claus Guttesen") Apr 28, 2008 at 06:19 PM

>  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

-- 
Sent via pgsql-performance mailing list (pgsql-performance@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
 




 8 Posts in Topic:
Where do a novice do to make it run faster?
gentosaker@[EMAIL PROTECT  2008-04-28 17:56:27 
Re: Where do a novice do to make it run faster?
Dennis Muhlestein <djm  2008-04-28 10:10:35 
Re: Where do a novice do to make it run faster?
kometen@[EMAIL PROTECTED]  2008-04-28 18:19:30 
Re: Where do a novice do to make it run faster?
scrawford@[EMAIL PROTECTE  2008-04-28 09:34:14 
Re: Where do a novice do to make it run faster?
Chris Browne <cbbrowne  2008-04-28 12:35:18 
Re: Where do a novice do to make it run faster?
lists@[EMAIL PROTECTED]   2008-04-28 20:23:12 
Re: Where do a novice do to make it run faster?
gentosaker@[EMAIL PROTECT  2008-04-29 11:09:48 
Re: Where do a novice do to make it run faster?
tgl@[EMAIL PROTECTED] (T  2008-04-29 10:20:48 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 7:11:17 CST 2008.