Thread: postgresql tuning

---

We have the perfect Group for you. Check out the handy changes to Yahoo! Groups.

jennifer llerena wrote:
> hi everyone.
>
>   I want to learn about tuning a postgresql database.
>   Any documentation i will apreciate!!!
>
>   Regards,
>   Jennifer
>

Assuming you have PostgreSQL installed the next place to look is the docs -
http://www.postgresql.org/docs/8.1/interactive/runtime-config.html
starts explaining the configuration options you have.

http://www.powerpostgresql.com/Downloads/annotated_conf_80.html
will explain these settings some more.

Some others to look at (in no particular order) -
http://www.informit.com/articles/printerfriendly.asp?p=24663&rl=1
http://www.varlena.com/GeneralBits/Tidbits/perf.html
http://www.powerpostgresql.com/PerfList

In a more general approach most SQL references explain good database
design - the way you design your tables and specify your indexes can
make a difference just as much as changing the right server option can.


--

Shane Ambler
pgSQL@007Marketing.com

Get Sheeky @ http://Sheeky.Biz

am  Fri, dem 27.10.2006, um 21:01:41 -0700 mailte jennifer llerena folgendes:
> hi everyone.
>
> I want to learn about tuning a postgresql database.
> Any documentation i will apreciate!!!

The question is, what exactly do you want to optimize? The database configuration
or your own SQL-Querys?


I think, the default parameters (in postgresql.conf) are okay for the
most cases. But, not problem, i have any links for you:

08:04 < akretschmer> ??tuning
08:04 < rtfm_please> For information about tuning
08:04 < rtfm_please> see http://www.powerpostgresql.com
08:04 < rtfm_please> or http://www.powerpostgresql.com/PerfList
08:04 < rtfm_please> or http://www.revsys.com/writings/postgresql-performance.html

(This is from the doc-bot in the IRC-Channel #postgresql)


If you ask how about query-tuning, then you should read more about
indexes, vacuum and explain analyze:

08:08 < akretschmer> ??index
08:08 < rtfm_please> For information about index
08:08 < rtfm_please> see http://www.postgresql.org/docs/current/static/bookindex.html
08:08 < rtfm_please> or http://www.postgresql.org/docs/current/static/indexes-expressional.html
08:08 < rtfm_please> or http://www.postgresql.org/docs/current/static/indexes-partial.html
08:08 < akretschmer> ??vacuum
08:08 < rtfm_please> For information about vacuum
08:08 < rtfm_please> see http://developer.postgresql.org/~wieck/vacuum_cost/
08:08 < rtfm_please> or http://www.postgresql.org/docs/current/static/sql-vacuum.html
08:08 < rtfm_please> or http://www.varlena.com/varlena/GeneralBits/116.php
08:08 < akretschmer> ??analyze
08:08 < rtfm_please> For information about analyze
08:08 < rtfm_please> see http://www.postgresql.org/docs/current/static/sql-analyze.html
08:08 < rtfm_please> or http://www.postgresql.org/docs/current/static/sql-explain.html
08:08 < rtfm_please> or http://www.postgresql.org/docs/current/static/sql-vacuum.html


HTH, Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47215,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

jennifer llerena wrote:

hi everyone.

 

I want to learn about tuning a postgresql database.

Any documentation i will apreciate!!!

We offer a performance and tuning course - if you're interested in the instructor-led training route.
http://otg-nc.com/training-courses/coursedetail.php?courseid=47&cat_id=8

Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC  27560
Phone: 877-258-8987/919-463-0999

 

Regards,

Jennifer

---

We have the perfect Group for you. Check out the handy changes to Yahoo! Groups.