Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux