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) gi
On Fri, Mar 29, 2013 at 8:31 AM, Franck Routier wrote:
> 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 performa
> > 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 serve
Franck Routier 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 established DB against the top resul
On Fri, Mar 29, 2013 at 7:20 AM, Franck Routier wrote:
> 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.
> There is no si
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 (dif
Franck Routier 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
> (https://launchpad.net/tpc-b) gives mediocre
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
(https://launchpad.net/tp
