Re: Question on restoring and compiled plans

From: Richard Huxton <dev(at)archonet(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Question on restoring and compiled plans
Date: 2004-03-19 15:28:56
Message-ID: 200403191528.56259.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Friday 19 March 2004 15:04, Tom Lane wrote:
> Richard Huxton <dev(at)archonet(dot)com> writes:
> > If I pg_restore a DB and don't ANALYSE before a pl/pgsql trigger
> > activates then that trigger's going to be planned based on the default
> > stats forever isn't it?
>
> Only for the life of the current backend(s).

Ah that's alright then. ANALYZE is usually the first thing I do after a
restore anyway, but thought I'd check how important it was that I remember.

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Larry Rosenman 2004-03-19 15:47:57 Re: [HACKERS] UnixWare/CVS Tip/initdb.c needs to use
Previous Message Fabien COELHO 2004-03-19 15:24:45 Re: pg_advisor schema proof of concept