Re: Clearing plans

From: "Peter Kovacs" <peter(dot)kovacs(dot)1(dot)0rc(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Scott Ribe" <scott_ribe(at)killerbytes(dot)com>, "pgsql-general postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Clearing plans
Date: 2007-01-18 21:08:24
Message-ID: b6e8f2e80701181308l751d9a5dtd0369831265f1b74@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Are the plans cached per connection? Why not globally?

Thanks
Peter

On 1/18/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Scott Ribe <scott_ribe(at)killerbytes(dot)com> writes:
> > Is there a way to force a flush of all cached plans?
>
> Start a fresh connection.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message volunteer 2007-01-18 21:17:10 apt-get install postgresql.deb??
Previous Message Scott Ribe 2007-01-18 20:48:28 Re: Finding bogus dates