Re: PostgreSQL Caching

From: "Adnan DURSUN" <a_dursun(at)hotmail(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: PostgreSQL Caching
Date: 2006-10-04 02:24:19
Message-ID: BAY106-DAV9D9180B1B9317BC3A34A7FA1D0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-performance

----- 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Sreeni 2006-10-04 06:34:29 Re: relocation error :/usr/lib/libpq.so.3 :undefined symbol krb5_cc_get_principal
Previous Message Tomeh, Husam 2006-10-04 01:29:26 Re: PostgreSQL Caching

Browse pgsql-performance by date

  From Date Subject
Next Message simon godden 2006-10-04 07:48:03 simple case using index on windows but not on linux
Previous Message Tomeh, Husam 2006-10-04 01:29:26 Re: PostgreSQL Caching