Postgres Pro
Downloads
Home   >   mailing lists

Re: How to get FK to use new index without restarting the database - Mailing list pgsql-performance

From Tom Lane
Subject Re: How to get FK to use new index without restarting the database
Date
Msg-id 22394.1292516874@sss.pgh.pa.us
Whole thread Raw
In response to How to get FK to use new index without restarting the database  (Eric Comeau <ecomeau@signiant.com>)
Responses 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>)
List pgsql-performance
Tree view 
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 by date:

Previous
From: "Pierre C"
Date:
Subject: Re: Help with bulk read performance
Next
From: Mladen Gogala
Date:
Subject: Re: Index Bloat - how to tell?