Le 29/03/2013 15:20, Franck Routier a écrit :
Hi,
I have a postgresql database (8.4) running in production whose
performance is degrading.
There is no single query that underperforms, all queries do.
Another interesting point is that a generic performance test
(https://launchpad.net/tpc-b)
I don't know that tcp-b does
tpcb.jar is a java implementation of the http://www.tpc.org/tpcb/
benchmark. It is not particularly representative of my workload, but
gives a synthetic, db-agnostic, view of the system performance.
We use it to have quick view to compare differents servers
On Fri, Mar 29, 2013 at 8:31 AM, Franck Routier franck.rout...@axege.comwrote:
Hi,
I don't know that tcp-b does
tpcb.jar is a java implementation of the http://www.tpc.org/tpcb/benchmark.
It is not particularly representative of my workload, but gives
a synthetic, db-agnostic, view of
Hi,
I have a postgresql database (8.4) running in production whose
performance is degrading.
There is no single query that underperforms, all queries do.
Another interesting point is that a generic performance test
(https://launchpad.net/tpc-b) gives mediocre peformance when run on the
On 03/29/2013 15:20, Franck Routier wrote:
Hi,
Hello,
I have a postgresql database (8.4) running in production whose
performance is degrading.
There is no single query that underperforms, all queries do.
Another interesting point is that a generic performance test
Franck Routier franck.routier 'at' axege.com writes:
Hi,
I have a postgresql database (8.4) running in production whose
performance is degrading.
There is no single query that underperforms, all queries do.
Another interesting point is that a generic performance test
Hi,
I don't know that tcp-b does
tpcb.jar is a java implementation of the http://www.tpc.org/tpcb/
benchmark. It is not particularly representative of my workload, but
gives a synthetic, db-agnostic, view of the system performance.
We use it to have quick view to compare differents servers
On Fri, Mar 29, 2013 at 7:20 AM, Franck Routier franck.rout...@axege.comwrote:
Hi,
I have a postgresql database (8.4) running in production whose performance
is degrading.
There have been substantial improvements in performance monitoring in newer
versions, so using 8.4 limits your options.
Franck Routier franck.routier 'at' axege.com writes:
http://wiki.postgresql.org/wiki/Show_database_bloat
How do I interpret the output of this query ? Is 1.1 bloat level on a
table alarming, or quite ok ?
I am not very used to this, but I'd start by comparing the top
result in your