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..
>
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 |