Re: FAQ: how to read EXPLAYN ANALYZE and act upon - Mailing list pgsql-general

From Greg Smith
Subject Re: FAQ: how to read EXPLAYN ANALYZE and act upon
Date
Msg-id Pine.GSO.4.64.0809171230080.5727@westnet.com
Whole thread Raw
In response to FAQ: how to read EXPLAYN ANALYZE and act upon  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Rodrigo E. De León Plicet"
Date:
Subject: Re: FAQ: how to read EXPLAYN ANALYZE and act upon
Next
From: Mike Diehl
Date:
Subject: Design question