Re: PostgreSQL Caching

Поиск
Список
Период
Сортировка
От Adnan DURSUN
Тема Re: PostgreSQL Caching
Дата
Msg-id BAY106-DAV9D9180B1B9317BC3A34A7FA1D0@phx.gbl
обсуждение исходный текст
Ответ на Re: PostgreSQL Caching  ("Tomeh, Husam" <htomeh@firstam.com>)
Ответы Re: PostgreSQL Caching  ("Dave Dutcher" <dave@tridecap.com>)
Список 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 по дате отправления:

Предыдущее
От: "Tomeh, Husam"
Дата:
Сообщение: Re: PostgreSQL Caching
Следующее
От: "simon godden"
Дата:
Сообщение: simple case using index on windows but not on linux