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

Поиск
Список
Период
Сортировка
От Eric Comeau
Тема Re: How to get FK to use new index without restarting the database
Дата
Msg-id 35FABCF85D99464FB00BC5123DC2A70A0BC2CF36@s228130hz1ew09.apptix-01.savvis.net
обсуждение исходный текст
Ответ на Re: How to get FK to use new index without restarting the database  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance


On 10-12-16 11:27 AM, Tom Lane wrote:

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

We confirmed that disconnecting and reconnecting resolves the issue.

Thanks to all that helped.

Eric

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

Предыдущее
От: selvi88
Дата:
Сообщение: postgres performance tunning
Следующее
От: Royce Ausburn
Дата:
Сообщение: Auto-clustering?