Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group