Skip site navigation (1) Skip section navigation (2)

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

From: "Eric Comeau" <Eric(dot)Comeau(at)signiant(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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:46:26
Message-ID: 35FABCF85D99464FB00BC5123DC2A70A0BC2CF36@s228130hz1ew09.apptix-01.savvis.net (view raw or flat)
Thread:
Lists: pgsql-performance

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.

Eric

In response to

pgsql-performance by date

Next:From: Mladen GogalaDate: 2010-12-16 19:27:08
Subject: Re: Index Bloat - how to tell?
Previous:From: Tom LaneDate: 2010-12-16 16:27:54
Subject: Re: How to get FK to use new index without restarting the database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group