| From: | Arguile <arguile(at)lucentstudios(dot)com> |
|---|---|
| To: | Hunter Hillegas <lists(at)lastonepicked(dot)com> |
| Cc: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Best PostgreSQL Tuning Reference |
| Date: | 2003-02-21 19:45:51 |
| Message-ID: | 1045856752.7330.27.camel@broadswd |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 2003-02-21 at 13:51, Hunter Hillegas wrote:
> What is the best reference out there for tuning PostgreSQL? Looking for a
> Web site or a book that has some info.
Query, Index, Database Tuning:
http://www.postgresql.org/docs/aw_pgsql_book/node106.html
http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/performance-tips.html
http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/indexes-examine.html
http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/admin.html
Tuning for your Hardware:
http://www.ca.postgresql.org/docs/momjian/hw_performance/
> Specifically, figuring out where bottlenecks are in a production system and
> the best way to tweak parameters, indices, queries... Obviously it will not
> be specific to my applications but I'm sure I could learn something.
Past the official online documentation and the online books listed on
the main site there are some other good resources.
* newgroup archives
* google :)
* techdocs.postgresql.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2003-02-21 19:57:36 | Re: Problem with functional indexes |
| Previous Message | Cristian Custodio | 2003-02-21 19:44:59 | Re: Mutating table (urgent) |