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
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
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
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
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