回复:there is a great difference between the query execution time and the log record time - Mailing list pgsql-general

From 邓彪
Subject 回复:there is a great difference between the query execution time and the log record time
Date
Msg-id 1c557238.8bce.161767f6f1e.Coremail.dbyzaa@163.com
Whole thread Raw
In response to Re: there is a great difference between the query execution time andthe log record time  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: 回复:there is a great difference between the query execution time and the log record time
List pgsql-general
i test psql on local and remote server are the same!
the jdbc remote client is display data on web page!


邓彪
邮箱:dbyzaa@163.com

签名由 网易邮箱大师 定制

2018年02月09日 01:33Adrian Klaver 写道:
On 02/08/2018 09:14 AM, 邓彪 wrote:
> the client on the remote server!!!

So when you did the psql test was that local to the server or remote?

Also what is the JDBC remote client doing with the data?
For example is is feeding a GUI form?

>
>
>    
> 邓彪
> 邮箱:dbyzaa@163.com
>
> <https://maas.mail.163.com/dashi-web-extend/html/proSignature.html?iconUrl=http%3A%2F%2Fmail-online.nosdn.127.net%2F3bcc55931047f433c5f7e66cbb7c36b1.jpg&name=%E9%82%93%E5%BD%AA&uid=example%40163.com&ftlId=3&items=%5B%22%E9%82%AE%E7%AE%B1%EF%BC%9Adbyzaa%40163.com%22%5D>
>
>
> 签名由 网易邮箱大师 <https://mail.163.com/dashi/dlpro.html?from=mail88> 定制
>
> On 02/09/2018 00:54, Adrian Klaver <mailto:adrian.klaver@aklaver.com>
> wrote:
>
>     On 02/08/2018 08:51 AM, nemo wrote:
>      > Hi,the client is jdbc.
>
>     Is the client on the server or is it remote?
>
>     I am not a Java programmer, but for those that are and might be able to
>     help could you provide the code that runs the query?
>
>      >
>      >
>      >
>      > --
>      > Sent from:
>     http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
>      >
>
>
>     --
>     Adrian Klaver
>     adrian.klaver@aklaver.com
>


--
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: there is a great difference between the query execution time andthe log record time
Next
From: Steven Hirsch
Date:
Subject: Re: Odd behavior with 'currval'