Re: FAQ: how to read EXPLAYN ANALYZE and act upon

On Wed, 17 Sep 2008, Ivan Sergio Borgonovo wrote:

> I'm looking for a tutorial that will teach me how to read explain
> analyze and maybe point me to some solutions (rewriting the query,
> adding some indexes, tune postgres.conf...).

All of the EXPLAIN tutorials and tools I'm aware of are listed at
http://wiki.postgresql.org/wiki/Using_EXPLAIN and the primary things to
tune in the postgresql.conf are described at
http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD