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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Eric Comeau <ecomeau(at)signiant(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: How to get FK to use new index without restarting the database
Date: 2010-12-16 16:27:54
Message-ID: 22394.1292516874@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Eric Comeau <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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Eric Comeau 2010-12-16 16:46:26 Re: How to get FK to use new index without restarting the database
Previous Message Pierre C 2010-12-16 15:22:40 Re: Help with bulk read performance