Re: Buffers and query's

From: Barry Lind <blind(at)xythos(dot)com>
To: Cris <cris(at)dmcid(dot)net>
Cc: PostgreSQL JDBC <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Buffers and query's
Date: 2003-05-12 16:16:17
Message-ID: 3EBFC8D1.5060408@xythos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Cris,

If I understand you correctly, I don't think you need to do anything.
The postgres jdbc driver doesn't cause any query plans to be cached. So
there is nothing to flush (unless you are using server side prepared
statements by calling PGStatement.setUserServerPrepare()).

thanks,
--Barry

Cris wrote:
> Hi
> I want do something that can seem a little bit strange: I'm doing a
> project and I don't want that the executing plan was known by the
> sistem.
> I've got many different query's and some of them are nearly similar.
> I have to know how many time it takes to postgresql to do my project.
>
> I've been looking for something similar to: *alter system flush
> shared_pool, *used in Oracle system, but i haven't found nothing.
>
> Does anybody have any idea to do this?
>
> yours
>
> Cris..
>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message anon permutation 2003-05-13 05:54:49 Re: Strange column naming problem
Previous Message Barry Lind 2003-05-12 16:07:16 Re: Strange column naming problem