Re: [GENERAL] Background worker assistance & review

2015-04-21 Thread Keith Fiske
On Tue, Apr 21, 2015 at 5:47 PM, Keith Fiske wrote: > > > > > > On Fri, Apr 10, 2015 at 1:00 PM, Keith Fiske wrote: > >> >> On Thu, Apr 9, 2015 at 11:56 PM, Craig Ringer >> wrote: >> >>> >>> >>> On 9 April 2015 at 05:35, Keith Fiske wrote: >>>

Re: [GENERAL] Background worker assistance & review

2015-04-21 Thread Keith Fiske
On Fri, Apr 10, 2015 at 1:00 PM, Keith Fiske wrote: > > On Thu, Apr 9, 2015 at 11:56 PM, Craig Ringer > wrote: > >> >> >> On 9 April 2015 at 05:35, Keith Fiske wrote: >> >>> I'm working on a background worker (BGW) for my pg_partman extension. >>> I've gotten the basic

[GENERAL] Performance tuning assisted by a GUI application

2015-04-21 Thread Jacek Wielemborek
Hello, I had a brief discussion on #postgresql and thought that perhaps there might be a need for a tool that would enable a fine-tuning of PostgreSQL performance settings by conveniently testing them with a sample SQL query with the aid of a simple GUI application. To illustrate this, I created t

Re: [GENERAL] What constitutes "reproducible" numbers from pgbench?

2015-04-21 Thread Andy Colson
On 4/21/2015 9:21 AM, holger.friedrich-fa-triva...@it.nrw.de wrote: Hello list, Exactly what constitutes „reproducible“ values from pgbench? I keep getting a range between 340 tps and 440 tps or something like that using the same command line on the same machine. Is that reproducible enough? Th

Re: [GENERAL] What constitutes "reproducible" numbers from pgbench?

2015-04-21 Thread Qingqing Zhou
On Tue, Apr 21, 2015 at 7:21 AM, wrote: > Hello list, > > Exactly what constitutes „reproducible“ values from pgbench? I keep getting > a range between 340 tps and 440 tps or something like that using the same > command line on the same machine. Is that reproducible enough? > Nope, it is not. Is

[GENERAL] What constitutes "reproducible" numbers from pgbench?

2015-04-21 Thread Holger.Friedrich-Fa-Trivadis
Hello list, Exactly what constitutes "reproducible" values from pgbench? I keep getting a range between 340 tps and 440 tps or something like that using the same command line on the same machine. Is that reproducible enough? The docs state that one should verify that the numbers are reproduci