Re: [HACKERS] [REVIEW] Re: Compression of full-page-writes

members showed the test result and them consideration. It's very objective comparing. Best Regards, -- Mitsumasa KONDO

Re: [HACKERS] add modulo (%) operator to pgbench

2014-09-11 15:47 GMT+09:00 Fabien COELHO coe...@cri.ensmp.fr: Hello Robert, I am not objecting to the functionality; I'm objecting to bolting on ad-hoc operators one at a time. I think an expression syntax would let us do this in a much more scalable way. If I had time, I'd go do that,

Re: [HACKERS] pgbench throttling latency limit

Hi, I find typo in your patch. Please confirm. @line 239 - agg-sum2_lag = 0; + agg-sum_lag = 0; And back patch is welcome for me. Best Regards, -- Mitsumasa KONDO

Re: [HACKERS] add modulo (%) operator to pgbench

Hi, Here is the review result. #1. Patch compatibility Little bit hunk, but it can patch to latest master. #2. Functionality No problem. #3. Documentation I think modulo operator explanation should put at last at the doc line. Because the others are more frequently used. #4. Algorithm You

Re: [HACKERS] add modulo (%) operator to pgbench

of explanation in five formulas. Fix version is here. Please confirm, and I mark it for ready for commiter. Best regards, -- Mitsumasa KONDO pgbench-modulo-4-1.patch Description: Binary data -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription

Re: [HACKERS] postgresql latency bgwriter not doing its job

and distributed buffer search using multi process or threads. Regards, -- Mitsumasa KONDO

Re: [HACKERS] posix_fadvise() and pg_receivexlog

need no or less fsync() option for the better performance. It is general in NOSQL storages. If no, we need fsync() option for more getting reliability and data integrarity. Best regards, -- Mitsumasa KONDO

Re: [HACKERS] add modulo (%) operator to pgbench

3, it is simple and practical. And it's enough in pgbench. If someone wants to use other implementation of modulo algorithm, he just changes his source code. Best regards, -- Mitsumasa KONDO

Re: [HACKERS] gaussian distribution pgbench -- splits v4

and not accurate very much. By the way, I don't know relativeness of this topic and command line option... Well whatever... Regards, -- Mitsumasa KONDO

Re: [HACKERS] gaussian distribution pgbench -- splits v4

these as additional contrib files be more acceptable? Something like tpc-b-gauss.sql... Otherwise there is no example available to show the feature. I agree the test script and including command line options. It's not harm, and it's useful. Best regards, -- Mitsumasa KONDO

Re: [HACKERS] gaussian distribution pgbench -- splits Bv6

Thanks for your modify the patch! I confirmed that It seems to be fine. I think that our latest patch fill all community comment. So it is really ready for committer now. Best regards, -- Mitsumasa KONDO

Re: [HACKERS] gaussian distribution pgbench -- splits v4

+ standard deviation threshold: 5.0 + decile percents: 0.0% 0.1% 2.1% 13.6% 34.1% 34.1% 13.6% 2.1% 0.1% 0.0% + probability of max/min percent of the range: 4.0% 0.0% And I add the explanation about this in the document. I'm very appreciate for your works!!! Best regards, -- Mitsumasa KONDO

Re: [HACKERS] gaussian distribution pgbench

probability, isn't it? Maybe I and Fabien-san have a knowledge of mathematics, so we think decile percentage is common sense. But if it isn't common sense, I agree with adding about these explanation in the documents. Best regards, -- Mitsumasa KONDO

Re: [HACKERS] gaussian distribution pgbench

also think it is blocker. Command line feature is also needed. Besides, is there a other good method? Please share us. Best regards, -- Mitsumasa KONDO

Re: [HACKERS] gaussian distribution pgbench

. Attached patch is fixed version, please confirm it. #Of course, World Cup is being held now. I'm not hurry at all. Best regards, -- Mitsumasa KONDO *** a/contrib/pgbench/pgbench.c --- b/contrib/pgbench/pgbench.c *** *** 41,46 --- 41,47 #include math.h #include signal.h

Re: [HACKERS] [RFC] What should we do for reliable WAL archiving?

://directcp.sourceforge.net/direct_cp.html Regards, -- Mitsumasa KONDO NTT Open Source Software Center

Re: [HACKERS] gaussian distribution pgbench

Oh, sorry, I forgot to write URL referring picture. http://en.wikipedia.org/wiki/Normal_distribution http://en.wikipedia.org/wiki/Exponential_distribution regards, -- Mitsumasa KONDO 2014-03-15 17:50 GMT+09:00 Mitsumasa KONDO kondo.mitsum...@gmail.com: Hi 2014-03-15 15:53 GMT+09:00 Fabien

Re: [HACKERS] gaussian distribution pgbench

can use %lf format. Possibly I'm missing something? Sorry. I think nothing is missing. regards, -- Mitsumasa KONDO

Re: [HACKERS] gaussian distribution pgbench

distribution we want. We have no time to fix its very much... But I think almost part of patch have been completed. Regards, -- Mitsumasa KONDO NTT Open Source Software Center gaussian_and_exponential_pgbench_v6.patch Description: Binary data attachment: exponential=5.png gnuplot.sh Description

Re: [HACKERS] Add min and max execute statement time in pg_stat_statement

script little bit, for creating multiple sql files with various sleep time. Regards, -- Mitsumasa KONDO NTT Open Source Software Center

Re: [HACKERS] pg_basebackup and pg_stat_tmp directory

of pg_stat_statements, the external query file is always created there. +1. And, I'd like to also skip pg_log directory because security reason. If you have time and get community agreed, could you create these patch after committed your patch? I don't want to bother you. Regards, -- Mitsumasa KONDO NTT Open

Re: [HACKERS] Exposing currentTransactionWALVolume

see number of transactions and database volumes. I'd like to see more detail activities from WAL volume in each minutes or hours. It might be good for performance improvement by hackers, too Regards, -- Mitsumasa KONDO NTT Open Source Software Center

Re: [HACKERS] pg_basebackup and pg_stat_tmp directory

2014-01-31 Fujii Masao masao.fu...@gmail.com: On Fri, Jan 31, 2014 at 10:18 PM, Mitsumasa KONDO kondo.mitsum...@gmail.com wrote: 2014-01-31 Fujii Masao masao.fu...@gmail.com On Tue, Jan 28, 2014 at 5:51 PM, Magnus Hagander mag...@hagander.net wrote: On Tue, Jan 28, 2014 at 6:11 AM

Re: [HACKERS] Add min and max execute statement time in pg_stat_statement

in same server and same benchmark settings(clients and scale factor) as today's result. When you merge and see the results, you can confirm not to affect of performance in my patch. Regards, -- Mitsumasa KONDO NTT Open Source Software Center

Re: [HACKERS] Add min and max execute statement time in pg_stat_statement

? Please respond. Oh.. Very sorry... Last day, I tried to find Kumar mail at 20/11/2013. But I couldn't find it... Could you tell me e-mail title? My patch catches up with latest 9.4HEAD. Regards, -- Mitsumasa KONDO

Re: [HACKERS] Optimize kernel readahead using buffer access strategy

you have? Regards, -- Mitsumasa KONDO NTT Open Source Software Center

Re: [HACKERS] Time-Delayed Standbys

. Agreed on no delay for the delay patch, as shown by my commit. Our forecast was very accurate... Nice commit, Thanks! Regards, -- Mitsumasa KONDO NTT Open Source Software Center

Re: [HACKERS] Time-Delayed Standbys

only delay recovery position and can seen old delay table data. Cannot connect server is not hoped behavior. If you think this behavior is the best, I will set ready for commiter. And commiter will fix it better. Rregards, -- Mitsumasa KONDO NTT Open Source Software Center

Re: [HACKERS] Time-Delayed Standbys

right or another best way might be existed. Regards, -- Mitsumasa KONDO NTT Open Source Software Center

Re: [HACKERS] Time-Delayed Standbys

2013/12/4 Andres Freund and...@2ndquadrant.com On 2013-12-04 22:47:47 +0900, Mitsumasa KONDO wrote: 2013/12/4 Andres Freund and...@2ndquadrant.com When it happened, psql cannot connect standby server at all. I think this behavior is not good. It should only delay recovery position

[HACKERS] Add accurate option to pgbench

carefuly option before starting benchmark. Please give me comments. Regards, -- Mitsumasa KONDO NTT Open Source Software Center pgbench_accurate_option_v0.patch Description: Binary data -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription

[HACKERS] pg_fallocate

posix_fallocate(). It will be needed by sorted checkpoint and more faster vacuum command in near the future. If you get more detail information, please see linux manual. I go sight seeing in Dublin with Ishii-san now:-) Regards, -- Mitsumasa KONDO NTT Open Source Software pg_fallocate_v0

Re: [HACKERS] gaussian distribution pgbench

, -- Mitsumasa KONDO

Re: [HACKERS] gaussian distribution pgbench

You had accidentally added to the CF In Progress. Oh, I had completely mistook this CF schedule :-) Maybe, Horiguchi-san is same situation... However, because of your moving, I become first submitter in next CF. Thank you for moving :-) -- Mitsumasa KONDO

Re: [HACKERS] Failing start-up archive recovery at Standby mode in PG9.2.4

; I think that horiguchi's discovery point is after this point. We must fix that CreateRestartPoint() does not create illegal WAL File. Best regards, -- Mitsumasa KONDO