The subjects says it all.
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...).
I notice I HUGE difference reordering join.
Are there guidelines to reorder joint too?
On Wed, Sep 17, 2008 at 9:43 AM, Ivan Sergio Borgonovo
[EMAIL PROTECTED] wrote:
The subjects says it all.
A couple of links that may be of use:
http://pooteeweet.org/files/phpworks06/explaining_explain.pdf
http://redivi.com/~bob/oscon2005_pgsql_pdf/OSCON_Explaining_Explain_Public.pdf
Good
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