Re: How to get FK to use new index without restarting the database

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How to get FK to use new index without restarting the database
Дата
Msg-id 22394.1292516874@sss.pgh.pa.us
обсуждение исходный текст
Ответ на How to get FK to use new index without restarting the database  (Eric Comeau <ecomeau@signiant.com>)
Ответы Re: How to get FK to use new index without restarting the database  (Eric Comeau <ecomeau@signiant.com>)
Re: How to get FK to use new index without restarting the database  ("Eric Comeau" <Eric.Comeau@signiant.com>)
Список pgsql-performance
Дерево обсуждения 
Eric Comeau <ecomeau@signiant.com> writes:
> Is there a way force the db to re-evaluate its execution plan for a FK
> without bouncing the DB?

>   PostgreSQL 8.1.17

You don't need to bounce the whole DB, but you will need to start fresh
sessions.  We didn't add automatic invalidation of those plans until 8.3.

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Pierre C"
Дата:
Сообщение: Re: Help with bulk read performance
Следующее
От: Mladen Gogala
Дата:
Сообщение: Re: Index Bloat - how to tell?