when client thread big, the tps without connection time wrong
number of threads: 100
duration: 10 s
My 0.02 €:
I cannot test that on my laptop! What kind of server is this?
The thread start time is currently taken before thread creation. The
overhead of creating 100 threads compared to
The following bug has been logged on the website:
Bug reference: 8336
Logged by: Harsh Vardhan Upadhyay
Email address: harshmailbo...@gmail.com
PostgreSQL version: 9.2.2
Operating system: windows
Description:
Dear Sir/Mam,
I have migrated my database from SQL Server
HI,
thanks for your replay,
At 2013-07-26 15:17:17,"Fabien COELHO" wrote:
>
>> when client thread big, the tps without connection time wrong
>> number of threads: 100
>> duration: 10 s
>
>My 0.02 €:
>
>I cannot test that on my laptop! What kind of server is this?
>
The Server Is HP DL
Hi Pavan
Thanks for pointing out
Git commit looks like exact fix for our problem, and I can't reproduce bug
in 9.2.4 on Windows platform
But need to update our linux servers with real data to be sure.
Will return in couple of days.
Regards,
Euclid
From: Pavan Deolasee [
Seems clearly your mistake to me... you do realize that (null + z) is
always going to be null, right? Maybe your totals columns should have
been declared NOT NULL (and presumably DEFAULT 0) to avoid this
problem?
Adding some diagnostics to your function (and fixing all the syntax
errors) and runni