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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Eric Comeau <ecomeau@xxxxxxxxxxxx> 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

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux