Search Postgresql Archives

Re: 回复：there is a great difference between the query execution time and the log record time

Subject: Re: 回复：there is a great difference between the query execution time and the log record time
From: Adrian Klaver <adrian.klaver@xxxxxxxxxxx>
Date: Thu, 8 Feb 2018 10:13:26 -0800
Cc: pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <1c557238.8bce.161767f6f1e.Coremail.dbyzaa@163.com>
References: <2018020900352961683535@163.com> <86e3963f-856b-69f6-a683-4474b5cc757b@aklaver.com> <1518108711378-0.post@n3.nabble.com> <749dfedb-f8f3-20e9-275f-0ff363e4b2e7@aklaver.com> <37d1c1b9.8bb1.1617669abe6.Coremail.dbyzaa@163.com> <46953e9c-9cff-6b47-270c-032237a78955@aklaver.com> <1c557238.8bce.161767f6f1e.Coremail.dbyzaa@163.com>
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.6.0

On 02/08/2018 09:38 AM, 邓彪 wrote:

i test psql on local and remote server are the same！
the jdbc remote client is display data on web page！

To me that indicates there is overhead in the Java/JDBC/Web stack thatcausing the statement to take extra time to finish.



--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx

References:
- there is a great difference between the query execution time and the log record time
  - From: dbyzaa@xxxxxxx
- Re: there is a great difference between the query execution time and the log record time
  - From: Adrian Klaver
- Re: there is a great difference between the query execution time and the log record time
  - From: nemo
- Re: there is a great difference between the query execution time and the log record time
  - From: Adrian Klaver
- Re: there is a great difference between the query execution time and the log record time
  - From: 邓彪
- Re: there is a great difference between the query execution time and the log record time
  - From: Adrian Klaver
- 回复：there is a great difference between the query execution time and the log record time
  - From: 邓彪