Re: PostgreSQL Caching

From: Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>
To: Dave Dutcher <dave(at)tridecap(dot)com>
Cc: 'Adnan DURSUN' <a_dursun(at)hotmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL Caching
Date: 2006-10-04 13:47:05
Message-ID: 1159969625.15773.19.camel@dba5.int.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-performance

On Wed, 2006-10-04 at 07:38 -0500, Dave Dutcher wrote:
> > -----Original Message-----
> > From: pgsql-performance-owner(at)postgresql(dot)org
> > [mailto:pgsql-performance-owner(at)postgresql(dot)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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Brad Nicholson 2006-10-04 13:52:26 Re: PostgreSQL Caching
Previous Message Dave Dutcher 2006-10-04 12:38:00 Re: PostgreSQL Caching

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Huxton 2006-10-04 13:47:33 Re: simple case using index on windows but not on linux
Previous Message Dave Dutcher 2006-10-04 12:38:00 Re: PostgreSQL Caching