Re: [PERFORM] Queries Per Second (QPS)

2015-09-30 Thread Josh Berkus
On 09/26/2015 09:24 AM, Adam Scott wrote: > How do we measure queries per second (QPS), not transactions per second, > in PostgreSQL without turning on full logging which has a performance > penalty and can soak up lots of disk space? Measure it from the client side. pgBench does this. If you me

Re: [PERFORM] Queries Per Second (QPS)

2015-09-27 Thread Jeff Janes
On Sat, Sep 26, 2015 at 11:06 PM, Guillaume Lelarge wrote: > Le 27 sept. 2015 8:02 AM, "Guillaume Lelarge" a > écrit : > > > > Le 26 sept. 2015 6:26 PM, "Adam Scott" a > écrit : > > > > > > How do we measure queries per second (QPS), not transactions per > second, in PostgreSQL without turning

Re: [PERFORM] Queries Per Second (QPS)

2015-09-26 Thread Guillaume Lelarge
Le 27 sept. 2015 8:02 AM, "Guillaume Lelarge" a écrit : > > Le 26 sept. 2015 6:26 PM, "Adam Scott" a écrit : > > > > How do we measure queries per second (QPS), not transactions per second, in PostgreSQL without turning on full logging which has a performance penalty and can soak up lots of disk

Re: [PERFORM] Queries Per Second (QPS)

2015-09-26 Thread Guillaume Lelarge
Le 26 sept. 2015 6:26 PM, "Adam Scott" a écrit : > > How do we measure queries per second (QPS), not transactions per second, in PostgreSQL without turning on full logging which has a performance penalty and can soak up lots of disk space? > The only way I can think of is to write an extension th

[PERFORM] Queries Per Second (QPS)

2015-09-26 Thread Adam Scott
How do we measure queries per second (QPS), not transactions per second, in PostgreSQL without turning on full logging which has a performance penalty and can soak up lots of disk space? We are using 8.4, but I'm interested in any version as well. Thank you, Adam C. Scott