Postgres Pro
Downloads
Home   >   mailing lists

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

From Eric Comeau
Subject Re: How to get FK to use new index without restarting the database
Date
Msg-id 35FABCF85D99464FB00BC5123DC2A70A0BC2CF36@s228130hz1ew09.apptix-01.savvis.net
Whole thread Raw
In response to Re: How to get FK to use new index without restarting the database  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view


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 by date:

Previous
From: selvi88
Date:
Subject: postgres performance tunning
Next
From: Royce Ausburn
Date:
Subject: Auto-clustering?