I am thinking about how to continuously monitor the performance of a
PostgreSQL 8 database. I am interested in two things: (1) the growth of
tables with TOAST and indexes; and (2) the respond time breakdown for a
In Chapters 23 and 24 of the big manual, I found enough materials to
teach me how to do the 1st job. But I have difficulty with the 2nd one.
I found some script for Oracle
Do we have something that can do the same job for PostgreSQL 8?
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2005-03-25 15:17:17|
|Subject: Re: Delete query takes exorbitant amount of time |
|Previous:||From: Simon Riggs||Date: 2005-03-25 15:10:48|
|Subject: Re: Delete query takes exorbitant amount of time|