Re: PostgreSQL Caching
- From: "Adnan DURSUN" <a_dursun(at)hotmail(dot)com>
- To: <pgsql-performance(at)postgresql(dot)org>
- Subject: Re: PostgreSQL Caching
- Date: Wed, 4 Oct 2006 05:24:19 +0300
- Message-id: <BAY106-DAV9D9180B1B9317BC3A34A7FA1D0(at)phx(dot)gbl>
----- Original Message -----
From: "Tomeh, Husam" <htomeh(at)firstam(dot)com>
To: "Adnan DURSUN" <a_dursun(at)hotmail(dot)com>;
<pgsql-performance(at)postgresql(dot)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
Home |
Main Index |
Thread Index