Re: [BUGS] BUG #8326: pgbench tps wrong BUG

2013-07-26 Thread Fabien COELHO
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

[BUGS] BUG #8336: pgAgent is not working

2013-07-26 Thread harshmailbox85
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

Re: [BUGS] BUG #8326: pgbench tps wrong BUG

2013-07-26 Thread digoal
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

Re: [BUGS] BUG #8334: Merge Join drops records

2013-07-26 Thread Euclid Nikiforov
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 [

Re: [BUGS] BUG #8329: UPDATE x SET x.y = x.y + z does not work in PL/pgSQL

2013-07-26 Thread Andrew Gierth
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