Re: PostgreSQL Caching - Mailing list pgsql-performance

From Adnan DURSUN
Subject Re: PostgreSQL Caching
Date
Msg-id BAY106-DAV9D9180B1B9317BC3A34A7FA1D0@phx.gbl
Whole thread Raw
In response to Re: PostgreSQL Caching  ("Tomeh, Husam" <htomeh@firstam.com>)
Responses Re: PostgreSQL Caching
List pgsql-performance
----- Original Message -----
From: "Tomeh, Husam" <htomeh@firstam.com>
To: "Adnan DURSUN" <a_dursun@hotmail.com>;
<pgsql-performance@postgresql.org>
Sent: Wednesday, October 04, 2006 4:29 AM
Subject: RE: [PERFORM] PostgreSQL Caching


>Query plans are not stored in the shared buffers and therefore can not
>be re-used by other sessions. They're only cached by the connection on a
>session level.

        Ok. i see. thanks..So that means that a stored object execution plan
saved before is destroyed from memory after it was altered or dropped by any
session. Is that true ?
        And last one :-)
                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 ?

Sincenerly !

Adnan DURSUN


pgsql-performance by date:

Previous
From: "Tomeh, Husam"
Date:
Subject: Re: PostgreSQL Caching
Next
From: "simon godden"
Date:
Subject: simple case using index on windows but not on linux