check_postgres_bloat

--_183482ae-cadf-4c55-a743-c4861609c49a_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Thanks everyone for the responses.

=20

It seems like the problem is actually that the check_postgres_bloat does no=
t check for index bloat=2C just table bloat=2C even though it says it check=
s for both.

=20

Below is my proof. Notice how this first check finds the indexes with idx =
in their name=2C but the second one doesn't. =20

=20

check_postgres.pl version 2.14.3
postgresq version is 8.3.9

=20

=20
/usr/local/nagios/libexec # ./check_postgres_index_size --dbservice=3Dthing=
-w 50 --include=3D~idx -c 100=20
=20
POSTGRES_INDEX_SIZE CRITICAL: service=3Dthing largest index is "thing1_idx"=
: 288 kB | time=3D1.00 =20
=20
/usr/local/nagios/libexec # ./check_postgres_bloat --dbservice=3Dthing -w 5=
0 --include=3D~idx -c 100 POSTGRES_BLOAT UNKNOWN: service=3Dthing No matchi=
ng relations found due to exclusion/inclusion options | time=3D0.18=20


=20
=20
____________________________________________________________ _____
The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with H=
otmail.=20
http://www.windowslive.com/campaign/thenewbusy?tile=3Dmultic alendar&ocid=3D=
PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5=

--_183482ae-cadf-4c55-a743-c4861609c49a_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable






Thanks everyone for the responses.

 =3B

It seems like the problem is actually that the check_postgres_bloat does no=
t check for index bloat=2C just table bloat=2C even though it says it check=
s for both.

 =3B

Below is my proof. =3B Notice how this first chec=
k finds the indexes with idx in their name=2C but the second one doesn't. PAN style=3D"mso-spacerun: yes"> =3B =


 =3B

check_postgres.pl version 2.14.3
postgresq version is 8.3.9

 =3B

=3DConsolas> =3B =3B > ce" /> =3B