Re: PostgreSQL Caching - Mailing list pgsql-performance

From Brad Nicholson
Subject Re: PostgreSQL Caching
Date
Msg-id 1159969625.15773.19.camel@dba5.int.libertyrms.com
Whole thread Raw
In response to Re: PostgreSQL Caching  ("Dave Dutcher" <dave@tridecap.com>)
List pgsql-performance
On Wed, 2006-10-04 at 07:38 -0500, Dave Dutcher wrote:
> > -----Original Message-----
> > From: pgsql-performance-owner@postgresql.org
> > [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of
> > Adnan DURSUN
> >                 i want to be can read an execution plan when
> > i look at it.
> > So, is there any doc about how it should be read ?
>
>
> You are asking how to read the output from EXPLAIN?  This page is a good
> place to start:
>
> http://www.postgresql.org/docs/8.1/interactive/performance-tips.html

Robert Treat's Explaining Explain presentation from OSCON is also very
good:

http://redivi.com/~bob/oscon2005_pgsql_pdf/OSCON_Explaining_Explain_Public.pdf#search=%22%22explaining%20explain%22%22

Brad.


pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: simple case using index on windows but not on linux
Next
From: "simon godden"
Date:
Subject: Re: simple case using index on windows but not on linux