On 10-12-16 11:27 AM, Tom Lane wrote:
Eric Comeau <ecomeau(at)signiant(dot)com> <mailto:ecomeau(at)signiant(dot)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.
In response to
pgsql-performance by date
|Next:||From: Mladen Gogala||Date: 2010-12-16 19:27:08|
|Subject: Re: Index Bloat - how to tell?|
|Previous:||From: Tom Lane||Date: 2010-12-16 16:27:54|
|Subject: Re: How to get FK to use new index without restarting the database |